Félicitations à Andres Freund pour son nouveau statut de commiteur PostgreSQL.

Les Commitfests pour la 9.5 commenceront les 15 juin, 15 août, 15 octobre, 15 décembre et 15 février. La Beta sera disponible en juin 2015.

La première PgConf suisse aura lieu le 24 juin 2014 au HSR Hochschule für Technik Rapperswil. http://www.postgres-conference.ch/

Le deuxième Hangout singapourien aura lieu le 28 mai 2014 à 16h30(SGT). RSVP : https://plus.google.com/u/0/events/cvpgsaauh8i1l8a7k22jqu5t0jo

Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en mai

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.

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.

(lien vers l'article original)

Correctifs appliqués

Bruce Momjian a poussé :

Tom Lane a poussé :

  • Fix non-C89-compatible coding in pgbench. C89 says that compound initializers may only contain constant expressions; a restriction violated by commit 89d00cbe. While we've had no actual field complaints about this, C89 is still the project standard, and it's not saving all that much code to break compatibility here. So let's adhere to the old restriction. In passing, replace a bunch of hardwired constants "256" with sizeof(target-variable), just because the latter is more readable and less breakable. And const-ify where possible. Back-patch to 9.3 where the nonportable code was added. Andres Freund and Tom Lane http://git.postgresql.org/pg/commitdiff/e41cc470bb57a0f3a765fa44b77ef104b5a5a01e
  • Update obsolete comment. Peter Geoghegan http://git.postgresql.org/pg/commitdiff/a0841ecd2518d4505b96132b764b918ab5d21ad4
  • Prevent auto_explain from changing the output of a user's EXPLAIN. Commit af7914c6627bcf0b0ca614e9ce95d3f8056602bf, which introduced the EXPLAIN (TIMING) option, for some reason coded explain.c to look at planstate->instrument->need_timer rather than es->timing to decide whether to print timing info. However, the former flag might get set as a result of contrib/auto_explain wanting timing information. We certainly don't want activation of auto_explain to change user-visible statement behavior, so fix that. Also fix an independent bug introduced in the same patch: in the code path for a never-executed node with a machine-friendly output format, if timing was selected, it would fail to print the Actual Rows and Actual Loops items. Per bug #10404 from Tomonari Katsumata. Back-patch to 9.2 where the faulty code was introduced. http://git.postgresql.org/pg/commitdiff/e416830a296f440acd67afd8599dde5411021fc4
  • Allow total number of transactions in pgbench to exceed INT_MAX. Change the total-transactions counters from int32 to int64 to accommodate cases where we do more than 2^31 transactions during a run. This patch does not change the INT_MAX limit on explicit "-t" parameters, but it does allow the product of the -t and -c parameters to exceed INT_MAX, or allow a -T limit that is large enough that more than 2^31 transactions can be completed. While pgbench did not actually fail in such cases, it did print an incorrect total-transactions count, and some of the derived numbers such as TPS would have been wrong as well. Tomas Vondra http://git.postgresql.org/pg/commitdiff/9a65fb350717360c505de9df411024d47e55710b

Fujii Masao a poussé :

Heikki Linnakangas a poussé :

Peter Eisentraut a poussé :

Robert Haas a poussé :

  • Remove unnecessary cleanup code. This is all inside a block guarded by op == DSM_OP_ATTACH, so it can never be the case that op == DSM_OP_CREATE. Reported by Coverity. http://git.postgresql.org/pg/commitdiff/11ad3b35c25de6edcaa8a7695cb1d58650c546d3
  • Andres Freund pushed
  • Silence a couple of spurious valgrind warnings in inval.c. Define padding bytes in SharedInvalidationMessage structs to be defined. Otherwise the sinvaladt.c ringbuffer, which is accessed by multiple processes, will cause spurious valgrind warnings about undefined memory being used. That's because valgrind remembers the undefined bytes from the last local process's store, not realizing that another process has written since, filling the previously uninitialized bytes. http://git.postgresql.org/pg/commitdiff/0564bbe7a1690f025f4424d5a12cb6af9d428c48
  • Don't allocate memory inside an Assert() iff in a critical section. HeapTupleHeaderGetCmax() asserts that it is only used if the tuple has been updated by the current transaction. That check is correct and sensible but requires allocating memory if xmax is a multixact. When wal_level is set to logical cmax needs to be included in a wal record , generated inside a critical section, which can trigger the assertion added in 4a170ee9e. Reported-By: Steve Singer http://git.postgresql.org/pg/commitdiff/9fa93530c878a0e23147a65f7d9a62802b22a995

Correctifs rejetés (à ce jour)

  • No one was disappointed this week :-)

Correctifs en attente

  • Jeff Davis sent in a patch to add some Assert()s to the range types SP-GiST code.
  • Teodor Sigaev sent in a patch to fix a memory leak in SP-GiST.
  • Yuto HAYAMIZU sent in a patch intended to fix a bug where the postmaster crashes with assertion and LWLOCK_STATS enabled.
  • Michael Paquier sent in two revisions of a doc patch to add a mention of logical slots in CREATE_REPLICATION_SLOT for the replication protocol.
  • David Rowley sent in another revision of a patch to allow join removals for more join types.
  • Shigeru HANADA sent in a patch to fix worker_spi to run as non-dynamic background worker.
  • Vik Fearing sent in a patch to add SQL access to database attributes.
  • Ronan Dunklau sent in another revision of a patch to add IMPORT FOREIGN SCHEMA.
  • Anastasia Lubennikova sent in a patch to add index-only scans for GiST.
  • Michael Paquier and Andres Freund traded patches to fix an issue where pg_recvlogical is not accepting -I to specify start LSN position.
  • Matteo Beccati sent in a patch to replace OSSP-UUID for Linux and BSD.
  • Michael Paquier sent in a patch to fix some typos in Solution.pm, one of the MSVC scripts.