Open Source Software for Business (OSS4B) 2013 aura lieu à Prato (Toscane, Italie) les 19 & 20 septembre. Les inscriptions sont ouvertes : http://www.oss4b.it/

Les nouveautés des produits dérivés

  • Mimeo 1.0.0, une extension de réplication apportant de multiples moyens de réplication avec un minimum de manipulations et de privilèges : https://github.com/omniti-labs/mimeo

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.

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

Robert Haas a poussé :

Alvaro Herrera a poussé :

Heikki Linnakangas a poussé :

  • Accept multiple -I, -P, -T and -n options in pg_restore. We already did this for -t (--table) in 9.3, but missed the other similar options. For consistency, allow all of them to be specified multiple times. Unfortunately it's too late to sneak this into 9.3, so commit to master only. http://git.postgresql.org/pg/commitdiff/da85fb4747ac0b7f787ef7a402adea2747e32d8e
  • Use a non-locking initial test in TAS_SPIN on x86_64. Testing done in 2011 by Tom Lane concluded that this is a win on Intel Xeons and AMD Opterons, but it was not changed back then, because of an old comment in tas() that suggested that it's a huge loss on older Opterons. However, didn't have separate TAS() and TAS_SPIN() macros back then, so the comment referred to doing a non-locked initial test even on the first access, in uncontended case. I don't have access to older Opterons, but I'm pretty sure that doing an initial unlocked test is unlikely to be a loss while spinning, even though it might be for the first access. We probably should do the same on 32-bit x86, but I'm afraid of changing it without any testing. Hence just add a note to the x86 implementation suggesting that we probably should do the same there. http://git.postgresql.org/pg/commitdiff/b03d196be055450c7260749f17347c2d066b4254

Tom Lane a poussé :

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • David Rowley and Vik Fearing traded patches to allow formatting in log_line_prefix.
  • Tarvi Pillessaar sent in another revision of a patch to add detail part for the "process x is still waiting for" lock message to show information about the lock holder and also show what the lock holder is actually doing.
  • Andrew (RhodiumToad) Gierth sent in another revision of a patch to add UNNEST with multiple arguments and TABLE with multiple functions.
  • Pavel Stehule sent in another revision of a patch to improve NUMERIC performance.
  • Michael Paquier sent in another revision of a patch to implement REINDEX CONCURRENTLY.
  • Heikki Linnakangas sent a trio of patches to: separate pg_dump -E from PGCLIENTENCODING, set client_encoding='auto' in all the client utilities, as already done in psql, and use iconv(3) in pg_restore to do encoding conversion in the client.
  • Alvaro Herrera sent in a patch to move src/port/pgcheckdir.c to src/common/checkdir.c and add the shareable part of postmaster's current checkDataDir code into it, as pg_check_dir_permissions.
  • Andres Freund sent in a patch to error out when building pg_xlogdump with PGXS.
  • Dimitri Fontaine sent in three more revisions of a patch to implement extension templates.
  • Heikki Linnakangas sent in another revision of a patch to allow freezing without write I/O.
  • KaiGai Kohei sent in another revision of a patch to implement row-level access controls.
  • Sawada Masahiko sent in another revision of a patch to fix synchronous standby priorities.
  • MauMau sent in another revision of a patch to clarify which versions of Solaris are supported.
  • Wang Shuo sent in a patch to allow disabling constraints by name and re-enabling them later.
  • Fujii Masao sent in a patch to allow compressing certain full-page writes.
  • KONDO Mitsumasa sent in a patch to add an option to pgbench which would checkpoint before starting the benchmark.
  • Andres Freund sent in more revisions of patches which are infrastructure for logical replication.
  • Tom Lane sent in a patch to enable variadic aggregates.
  • Peter Geoghegan sent in a patch to enable INSERT...ON DUPLICATE KEY IGNORE, and there was much rejoicing.
  • Stefan Kaltenbrunner sent in a patch to add an elevel argument to ProcessGUCArray and then call it with NOTICE in the case that check_function_bodies is true.
  • Jeff Janes sent in a patch to add the disable cost to the cost of materializing the inner scan when materialization is disabled.