L'appel international à conférenciers pour le PgDay équatorien, intégré à la Feria Internacional del Libro à Quito, Équateur, a été lancé. Écrivez à ecpug <AT> postgresql <DOT> org. Détails (en espagnol) ci-après : https://wiki.postgresql.org/wiki/PGDay_Ecuador_2013

Offres d'emplois autour de PostgreSQL en octobre

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

Heikki Linnakangas a poussé :

  • Fix snapshot leak if lo_open called on non-existent object. lo_open registers the currently active snapshot, and checks if the large object exists after that. Normally, snapshots registered by lo_open are unregistered at end of transaction when the lo descriptor is closed, but if we error out before the lo descriptor is added to the list of open descriptors, it is leaked. Fix by moving the snapshot registration to after checking if the large object exists. Reported by Pavel Stehule. Backpatch to 8.4. The snapshot registration system was introduced in 8.4, so prior versions are not affected (and not supported, anyway). http://git.postgresql.org/pg/commitdiff/357f7521384df34c697b3544115622520a6a0e9f
  • In bms_add_member(), use repalloc() if the bms needs to be enlarged. Previously bms_add_member() would palloc a whole-new copy of the existing set, copy the words, and pfree the old one. repalloc() is potentially much faster, and more importantly, this is less surprising if CurrentMemoryContext is not the same as the context the old set is in. bms_add_member() still allocates a new bitmapset in CurrentMemoryContext if NULL is passed as argument, but that is a lot less likely to induce bugs. Nicholas White. http://git.postgresql.org/pg/commitdiff/ee01d848f39400c8524c66944ada6fde47894978
  • Minor GIN code refactoring. It makes for cleaner code to have separate Get/Add functions for PostingItems and ItemPointers. A few callsites that have to deal with both types need to be duplicated because of this, but all the callers have to know which one they're dealing with anyway. Overall, this reduces the amount of casting required. Extracted from Alexander Korotkov's larger patch to change the data page format. http://git.postgresql.org/pg/commitdiff/c2b175b94851e59765cc87243d8faf923e3d820b

Andrew Dunstan a poussé :

Alvaro Herrera a poussé :

Bruce Momjian a poussé :

Magnus Hagander a poussé :

Peter Eisentraut a poussé :

Robert Haas a poussé :

Noah Misch a poussé :

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • David Rowley sent in a patch to use AppendStringInfo[type] functions instead of bare AppendStringInfo in various places throughout the source code.
  • Amit Kapila sent in another revision of a patch to implement ALTER SYSTEM.
  • Nicholas White sent in two more revisions of a patch to implement RESPECT/IGNORE NULLS in the LEAD and LAG window functions.
  • Andres Freund sent another flock of patches intended to be infrastructure for logical changeset extraction and replay.
  • Pavel Stehule sent in a patch atop the one for \pset which makes autocomplete work better.
  • Heikki Linnakangas sent in another revision of a patch to implement UNNEST with multiple arguments and TABLE with multiple functions.
  • Michael Paquier sent in another revision of a patch to implement REINDEX CONCURRENTLY.
  • Peter Eisentraut sent in another revision of a patch to use asprintf() where available.
  • Oskari Saarenmaa sent in a patch to add file cloning using BTRFS tools as an alternative data transfer method to pg_upgrade.
  • Rushabh Lathia sent in another revision of a patch to have INSERT et al throw an error when a year field has length greater than 4 for the timestamptz data type.
  • Kevin Grittner sent in three more revisions of a patch to fix an SSI freezing bug.
  • Sawada Masahiko sent in another revision of a patch to allow fail-back without a fresh backup.
  • Pavel Stehule sent in two revisions of a patch to optimize updates to fixed-length arrays.
  • KaiGai Kohei sent in another revision of a patch to insert machinery and examples for custom plan nodes.
  • Sameer Thakur sent in another revision of a patch to extend pg_stat_statements.
  • David Rowley sent in another revision of a patch to ensure that his previous patch to ensure that space reserved for WAL matches what is written doesn't break on 32-bit machines.
  • David Rowley sent in two revisions of a patch to improve performance of the column-wise INSERTs option in pg_dump.
  • Heikki Linnakangas sent in another revision of a patch to improve GIN index performance by adding more information to the index.
  • Marko (johto) Tiikkaja sent in another revision of a patch to add a plpgsql.print_strict_params GUC and associated machinery.
  • Noah Misch sent in a documentation patch to hold a place in pgbench for fixing an issue where estimation and short runs can be noticeably different.