Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en septembre

PostgreSQL Local

PostgreSQL dans les média

PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter. Traduction par l'équipe PostgreSQLFr sous licence CC BY-NC-SA. La version originale se trouve à l'adresse suivante : http://www.postgresql.org/message-id/20150913232302.GA19348@fetter.org

Proposez vos articles ou annonces avant dimanche 15:00 (heure du Pacifique). Merci de les envoyer en anglais à david (a) fetter.org, en allemand à pwn (a) pgug.de, en italien à pwn (a) itpug.org et en espagnol à pwn (a) arpug.com.ar.

Correctifs appliqués

Teodor Sigaev pushed:

Gregory Stark pushed:

Jeff Davis pushed:

  • Add log_line_prefix option 'n' for Unix epoch. Prints time as Unix epoch with milliseconds. Tomas Vondra, reviewed by Fabien Coelho. http://git.postgresql.org/pg/commitdiff/f828654e1097bdbb40fedebd9ac1ea045b183e15
  • Coordinate log_line_prefix options 'm' and 'n' to share a timeval. Commit f828654e introduced the 'n' option, but it invoked gettimeofday() independently of the 'm' option. If both options were in use (or multiple 'n' options), or if 'n' was in use along with csvlog, then the reported times could be different for the same log message. To fix, initialize a global variable with gettimeofday() once per log message, and use that for both formats. Don't bother coordinating the time for the 't' option, which has much lower resolution. Per complaint by Alvaro Herrera. http://git.postgresql.org/pg/commitdiff/b1e1862a123b6904d51fd0a607e30f5832bf9a1f

Ãlvaro Herrera pushed:

Noah Misch pushed:

  • In the pg_rewind test suite, receive WAL fully before promoting. If a transaction never reaches the standby, later tests find unexpected cluster state. A "tail-copy: query result matches" test failure has been the usual symptom. Among the buildfarm members having run this test suite, most have exhibited that symptom at least once. Back-patch to 9.5, where pg_rewind was introduced. Michael Paquier, reported by Christoph Berg. http://git.postgresql.org/pg/commitdiff/582fbffb0ccc79de76a459df670b86d109d37ca5

Fujii Masao pushed:

  • Improve tab-completion for GRANT and REVOKE. Thomas Munro, reviewed by Michael Paquier, modified by me. http://git.postgresql.org/pg/commitdiff/2f8880704a697312d8d10ab3a2ad7ffe4b5e3dfd
  • Add gin_fuzzy_search_limit to postgresql.conf.sample. This was forgotten in 8a3631f (commit that originally added the parameter) and 0ca9907 (commit that added the documentation later that year). Back-patch to all supported versions. http://git.postgresql.org/pg/commitdiff/043113e7982942279d940f9bf0e3a5a4b66b9aa7
  • Remove files signaling a standby promotion request at postmaster startup. This commit makes postmaster forcibly remove the files signaling a standby promotion request. Otherwise, the existence of those files can trigger a promotion too early, whether a user wants that or not. This removal of files is usually unnecessary because they can exist only during a few moments during a standby promotion. However there is a race condition: if pg_ctl promote is executed and creates the files during a promotion, the files can stay around even after the server is brought up to new master. Then, if new standby starts by using the backup taken from that master, the files can exist at the server startup and should be removed in order to avoid an unexpected promotion. Back-patch to 9.1 where promote signal file was introduced. Problem reported by Feike Steenbergen. Original patch by Michael Paquier, modified by me. Discussion: 20150528100705.4686.91426@wrigleys.postgresql.org http://git.postgresql.org/pg/commitdiff/96f6a0cb41ee06673960019f0026b1b0fd1e644d
  • Correct description of PageHeaderData layout in documentation. Back-patch to 9.3 where PageHeaderData layout was changed. Michael Paquier http://git.postgresql.org/pg/commitdiff/a1b28885177aff123cafe5a7f694555af33ad4e9

Andres Freund pushed:

Stephen Frost pushed:

Tom Lane pushed:

  • Fix minor bug in regexp makesearch() function. The list-wrangling here was done wrong, allowing the same state to get put into the list twice. The following loop then would clone it twice. The second clone would wind up with no inarcs, so that there was no observable misbehavior AFAICT, but a useless state in the finished NFA isn't an especially good thing. http://git.postgresql.org/pg/commitdiff/91cf3135b9079bf44ee9b4b445531987cdb7deee
  • Fix setrefs.c comment properly. The "typo" alleged in commit 1e460d4bd was actually a comment that was correct when written, but I missed updating it in commit b5282aa89. Use a slightly less specific (and hopefully more future-proof) description of what is collected. Back-patch to 9.2 where that commit appeared, and revert the comment to its then-entirely-correct state before that. http://git.postgresql.org/pg/commitdiff/87efbc2be12b07c77b7fa2d54d029329f56d6677

Peter Eisentraut pushed:

Robert Haas pushed:

Kevin Grittner pushed:

  • Fix an O(N^2) problem in foreign key references. Commit 45ba424f improved foreign key lookups during bulk updates when the FK value does not change. When restoring a schema dump from a database with many (say 100,000) foreign keys, this cache would grow very big and every ALTER TABLE command was causing an InvalidateConstraintCacheCallBack(), which uses a sequential hash table scan. This could cause a severe performance regression in restoring a schema dump (including during pg_upgrade). The patch uses a heuristic method of detecting when the hash table should be destroyed and recreated. InvalidateConstraintCacheCallBack() adds the current size of the hash table to a counter. When that sum reaches 1,000,000, the hash table is flushed. This fixes the regression without noticeable harm to the bulk update use case. Jan Wieck. Backpatch to 9.3 where the performance regression was introduced. http://git.postgresql.org/pg/commitdiff/5ddc72887a012f6a8b85707ef27d85c274faf53d

Bruce Momjian pushed:

  • pg_dump, pg_upgrade: allow postgres/template1 tablespace moves. Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg_upgrade to process new/old tablespaces separately in all cases. Report by Marti Raudsepp Patch by Marti Raudsepp, me Backpatch through 9.0 http://git.postgresql.org/pg/commitdiff/7f8d090b8966ef098f45537d42e47e296210145f

Andrew Dunstan pushed:

  • Fix the fastpath rule for jsonb_concat with an empty operand. To prevent perverse results, we now only return the other operand if it's not scalar, and if both operands are of the same kind (array or object). Original bug complaint and patch from Oskari Saarenmaa, extended by me to cover the cases of different kinds of jsonb. Backpatch to 9.5 where jsonb_concat was introduced. http://git.postgresql.org/pg/commitdiff/e7e3ac2d51130d707792e657facc58c160182342

Correctifs rejetés (à ce jour)

No one was disappointed this week :-)

Correctifs en attente

Thomas Munro sent in a patch to use memcmp() rather than numeric_cmp() in certain aggregation scenarios.

Thomas Munro sent in a patch to stabilize the pg_rewind TAP test.

Thomas Munro sent in another revision of a patch to add a GUC which allows synchronous commit to mean "apply."

Petr Jelinek and Michael Paquier traded patches to allow CREATE EXTENSION ... CASCADE, which would include all its dependencies.

Alexander Korotkov sent in another revision of a patch to add CREATE ACCESS METHOD.

Andres Freund sent in a PoC patch to separate Buffer LWLocks.

Etsuro Fujita sent in another revision of a patch to make FDW join pushdown and EvalPlanQual work together.

Pavel Stěhule and Alexander Shulgin traded patches to make it possible to get the explain of a running query by sending the backend a signal.

Michael Paquier sent in a patch to fix some messages in the SSL info functions.

Nathan Wagner sent in a patch to adjust the GEQO mutation swaps to avoid having to re-pick ties, and change the initialization and shuffling algorithm for the gene array to use an in-place Fisher-Yates shuffling algorithm.

Rajeev Rastogi sent in a patch to allow dumping memory context information to a file.

Jeff Janes sent in a patch to fix the tab completion for ALTER INDEX in psql.

Rugal Bernstein sent in a patch to add a better translation version of Chinese for psql/po/zh_CN.po file.

Robert Haas sent in another revision of a patch to allow the isolation tester to have >1 waiting process.

Thomas Munro sent in another revision of a patch to make psql's tab-complete.c easier to understand and maintain.

Michael Paquier sent in another revision of a patch to improve test coverage of extensions with pg_dump.

Stephen Frost sent in two more revisions of a patch to improve logging of TAP tests.

Robbie Harwood sent in another revision of a patch to add GSSAPI encryption support.

Pavel Stěhule sent in four more revisions of a patch to add a parse_ident() function.

Fabien COELHO sent in another revision of a patch to add pgbench progress with timestamp.

Etsuro Fujita sent in another revision of a patch to improve create_foreignscan_plan/ExecInitForeignScan.

Ashutosh Bapat sent in another revision of a patch to add tests for background worker notify.

Andres Freund sent in another revision of a patch to update the documented compiler requirements.

David Fetter sent in a patch to rework some test for contrib/tablefunc for legibility.

Michael Paquier sent in a patch to fix a typo in timeline.h regarding the meaning of infinity for a timeline history entry.

Fujii Masao sent in two more revisions of a patch to improve cancelbackup messages.

Fabien COELHO sent in another revision of a patch to add GUCs checkpoint_sort and checkpoint_warning.

Stephen Frost sent in a patch to remove the notion of SECURITY_ROW_LEVEL_DISABLED entirely.

Beena Emerson sent in another revision of a patch to add support for N synchronous standby servers.

Takashi Horikawa sent in four revisions of a patch to partition checkpointing.

КоÑÑ‚Ñ ÐšÑƒÐ·Ð½ÐµÑ†Ð¾Ð² (Kostya Kuznetzov) sent in a patch to add a new GiST vacuum.

Alexander Korotkov sent in another revision of a patch to rework the access method interface.

YUriy Zhuravlev sent in another revision of a patch to move PinBuffer and UnpinBuffer to atomics.

Etsuro Fujita sent in a patch to update some comments in pathnode.c.

Andrew Dunstan sent in a patch to fix the way jsonbconcat works.

Rahila Syed sent in two more revisions of a patch to add a VACUUM progress checker.

Amit Kapila sent in another revision of a patch to speed up clog access by increasing CLOG buffers.

Teodor Sigaev sent in another revision of a patch to add a --strict-names option to pg_dump.

David Rowley sent in another revision of a patch to make timestamptz_out less slow.

Charles Clavadetscher sent in four revisions of a patch to add COMMENT ON POLICY.

Kaigai Kouhei sent in a patch to fix a regtest policy for 9.2.

Ildus Kurbangaliev sent in another revision of a patch to refactor LWLock tranches.

Dean Rasheed and Stephen Frost traded patches to refactor RLS.