Le PGDay.IT 2014 aura lieu à Prato le 7 novembre 2014. La date limite pour le dépôt de candidature des conférenciers a été repoussée au 9 août : http://2014.pgday.it/call-for-papers-en/

Offres d'emplois autour de PostgreSQL en août

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

Tom Lane a poussé :

  • Fix obsolete statement in smgr/README. Since commit 2d00190495b22e0d0ba351b2cda9c95fb2e3d083, fork numbers are defined in relpath.h not relfilenode.h. Fabrízio de Royes Mello http://git.postgresql.org/pg/commitdiff/248fc1f10716964b7e7d0f8ada686801d1e36445
  • Avoid wholesale autovacuuming when autovacuum is nominally off. When autovacuum is nominally off, we will still launch autovac workers to vacuum tables that are at risk of XID wraparound. But after we'd done that, an autovac worker would proceed to autovacuum every table in the targeted database, if they meet the usual thresholds for autovacuuming. This is at best pretty unexpected; at worst it delays response to the wraparound threat. Fix it so that if autovacuum is nominally off, we *only* do forced vacuums and not any other work. Per gripe from Andrey Zhidenkov. This has been like this all along, so back-patch to all supported branches. http://git.postgresql.org/pg/commitdiff/f51ead09df19f0a074c07657b7de8dba0f3050d6

Fujii Masao a poussé :

Heikki Linnakangas a poussé :

  • Oops, fix recoveryStopsBefore functions for regular commits. Pointed out by Tom Lane. Backpatch to 9.4, the code was structured differently in earlier branches and didn't have this mistake. http://git.postgresql.org/pg/commitdiff/60d931827b0c37fbce74d04e45d0220d57ddd06a
  • Treat 2PC commit/abort the same as regular xacts in recovery. There were several oversights in recovery code where COMMIT/ABORT PREPARED records were ignored: pg_last_xact_replay_timestamp() (wasn't updated for 2PC commits), recovery_min_apply_delay (2PC commits were applied immediately), recovery_target_xid (recovery would not stop if the XID used 2PC) The first of those was reported by Sergiy Zuban in bug #11032, analyzed by Tom Lane and Andres Freund. The bug was always there, but was masked before commit d19bd29f07aef9e508ff047d128a4046cc8bc1e2, because COMMIT PREPARED always created an extra regular transaction that was WAL-logged. Backpatch to all supported versions (older versions didn't have all the features and therefore didn't have all of the above bugs). http://git.postgresql.org/pg/commitdiff/e74e0906fad5fcdcc807d4655cdc69dded5d58f2
  • Move log_newpage and log_newpage_buffer to xlog.c. log_newpage is used by many indexams, in addition to heap, but for historical reasons it's always been part of the heapam rmgr. Starting with 9.3, we have another WAL record type for logging an image of a page, XLOG_FPI. Simplify things by moving log_newpage and log_newpage_buffer to xlog.c, and switch to using the XLOG_FPI record type. Bump the WAL version number because the code to replay the old HEAP_NEWPAGE records is removed. http://git.postgresql.org/pg/commitdiff/54685338e37889eebd473804c3feb006dd83a882
  • Fix typo in user manual http://git.postgresql.org/pg/commitdiff/822ff44c822007ee14cacfebfe0792d1de669df9

Alvaro Herrera a poussé :

  • Simplify multixact freezing a bit. Testing for abortedness of a multixact member that's being frozen is unnecessary: we only need to know whether the transaction is still in progress or committed to determine whether it must be kept or not. This let us simplify the code a bit and avoid a useless TransactionIdDidAbort test. Suggested by Andres Freund awhile back. http://git.postgresql.org/pg/commitdiff/c2581794f37e76c910eb91f1bf1f1e581123abd6
  • Avoid uselessly looking up old LOCK_ONLY multixacts. Commit 0ac5ad5134f2 removed an optimization in multixact.c that skipped fetching members of MultiXactId that were older than our OldestVisibleMXactId value. The reason this was removed is that it is possible for multixacts that contain updates to be older than that value. However, if the caller is certain that the multi does not contain an update (because the infomask bits say so), it can pass this info down to GetMultiXactIdMembers, enabling it to use the old optimization. Pointed out by Andres Freund in 20131121200517.GM7240@alap2.anarazel.de http://git.postgresql.org/pg/commitdiff/05315498012530d44cd89a209242a243374e274d

Bruce Momjian a poussé :

Peter Eisentraut a poussé :

Robert Haas a poussé :

  • Fix mishandling of background worker PGPROCs in EXEC_BACKEND builds. InitProcess() relies on IsBackgroundWorker to decide whether the PGPROC for a new backend should be taken from ProcGlobal's freeProcs or from bgworkerFreeProcs. In EXEC_BACKEND builds, InitProcess() is called sooner than in non-EXEC_BACKEND builds, and IsBackgroundWorker wasn't getting initialized soon enough. Report by Noah Misch. Diagnosis and fix by me. http://git.postgresql.org/pg/commitdiff/e280c630a87e1b8325770c6073097d109d79a00f

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Laurenz Albe sent in a patch to make pg_dump behave consistently for different archive formats.
  • MauMau and Andres Freund traded patches to fix an issue with sinval.
  • Thomas Munro sent in three more revisions of a patch to add SKIP LOCKED DATA.
  • Furuya Osamu sent in another revision of a patch to add an synchronous mode to pg_receivexlog.
  • Keith Baker sent in a patch to add a QNX 6.5 port.
  • Fabien COELHO sent in two more revisions of a patch to fix some issues in the Gaussian distribution patch for pgbench.
  • Daniele Varrazzo sent in two revisions of a patch to fix redundant i18n strings in json.
  • Heikki Linnakangas sent in a patch to move log_newpage out of heapam.c.
  • Kyotaro HORIGUCHI sent in a patch to introduce coarse-grained parallelism via the postgres_fdw.
  • Vik Fearing sent in a patch to make the REINDEX syntax more useful.
  • Heikki Linnakangas sent in another revision of a patch to make WAL format and API changes.
  • Anastasia Lubennikova sent in another revision of a patch to add index-only scans for GiST.
  • Heikki Linnakangas sent in another revision of a patch to support Windows SChannel as an OpenSSL replacement.
  • Fabien COELHO sent in a patch to add the modulo (%) operator to pgbench.
  • David Rowley sent in a patch to fix the Windows build.
  • Peter Geoghegan sent in two more revisions of a patch to add a B-Tree support function which abbreviates certain searches.
  • Jeff Davis sent in a patch to explicitly track allocated memory (the blocks, not the chunks) for each memory context, as well as its children.
  • Emre Hasegeli sent in another revision of a patch to enable KNN-GiST with recheck.