Nouvelles hebdomadaires de PostgreSQL - 22 mars 2009
- Mises à jour de sécurité 8.3.7, 8.2.13, 8.1.17, 8.0.21 et 7.4.25 disponibles. Ces versions corrigent une possibilité de déni de service offerte par la conversion d'encodage, et il est conseillé à tous les utilisateurs de mettre à jour dès qu'une occasion raisonnable se présente.
- Les "bouts de code" (code snippets) sont maintenant hébergés sur le wiki :
http://wiki.postgresql.org/wiki/Snippets
- Fernando Ike de Oliveira a créé un groupe Identica sur PostgreSQL :
http://identi.ca/group/postgresql
- Le programme de la pgCon est en place :
http://www.pgcon.org/2009/schedule/
- Le PgDay de Brasilia aura lieu le 17 avril. Contactez [fernando.ike (a) gmail (point) com] ou [eduardo (a) planejamento (point) gov (point) br] pour participer.
- L'appel aux conférences est lancé pour le PgDay de São Paulo, programmé le 24 avril. Contactez [marins (point) consultoria (a) gmail (point) com] ou [marcelojscosta (a) gmail (point) com] pour participer.
- Il y aura également des PgDays les 29 et 30 avril, respectivement à Porto Velho (RO) et Ji-Parana (RO). Contactez Luis Fernando Bueno : [proflfbueno (a) gmail (point) com] pour participer.
Les nouveautés des produits dérivés
La fonctionnalité 8.4 de la semaine
Édition de fonctions : psql peut maintenant éditer les fonctions via la commande \ef qui lancera votre éditeur favori.
L'astuce de la semaine
bonnie++, dd, et iozone sont chacun de bons outils pour tester rapidement les performances de votre système de fichier. Si votre base de données est trop volumineuse pour tenir en RAM, ça ne pourra pas aller plus rapidement que le système de stockage !
(lien vers l'article original)
Offres d'emplois autour de PostgreSQL en mars
PostgreSQL Local
PostgreSQL dans les média
PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter et Josh Berkus. La traduction en est assurée par l'équipe PostgreSQLFr.
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.
Correctifs appliqués
Peter Eisentraut a commité :
- In pgsql/src/bin/pg_dump/pg_dump.c, add -w option to --help output. It was apparently forgotten when -w was implemented.
- Rename pg_restore -m to -j, and add documentation about what good numbers are. Per discussion on -hackers.
Bruce Momjian a commité :
- In pgsql/src/backend/utils/adt/datetime.c, document that datetime year '0' is considered in a recent century, not just '00'.
- In pgsql/src/backend/utils/adt/datetime.c, improve zero-year comments.
- In pgsql/doc/src/sgml/client-auth.sgml, clarify 'cert' authentication documention.
- In pgsql/doc/src/sgml/libpq.sgml, clarify libpq 'sslverify' documentation wording.
Tom Lane a commité :
- In pgsql/doc/src/sgml/release.sgml, add just-assigned CVE number to release notes for recent security issue.
- In pgsql/doc/src/sgml/intarray.sgml, be more clear about when to use gist__int_ops vs. gist__intbig_ops. Per suggestion from Ron Mayer.
- Optimize multi-batch hash joins when the outer relation has a nonuniform distribution, by creating a special fast path for the (first few) most common values of the outer relation. Tuples having hashvalues matching the MCVs are effectively forced to be in the first batch, so that we never write them out to the batch temp files. Bryce Cutt and Ramon Lawrence, with some editorialization by me.
- Remove the datetime keywords ABSTIME and RELTIME, which we'd been treating as noise words for the last twelve years, for compatibility with Berkeley-era output formatting of the special INVALID values for those datatypes. Considering that the datatypes themselves have been deprecated for awhile, this is taking backwards compatibility a little far. Per gripe from Josh Berkus.
- Remove the -d and -D options of pg_dump and pg_dumpall. The functionality is still available, but you must now write the long equivalent --inserts or --column-inserts. This change is made to eliminate confusion with the use of -d to specify a database name in most other Postgres client programs. Original patch by Greg Sabino Mullane, modified per subsequent discussion.
- Clean up pg_SSPI_error() coding a little bit: make the messages more consistent, translate where intended, const-ify declarations. Resolves a gripe from Alvaro Herrera as well as some stuff I didn't like.
- Add isExtend to the parameters of the buffer_read_start and buffer_read_done DTrace probes, so that ordinary reads can be distinguished from relation extension operations. Move buffer_read_start probe to before the smgrnblocks() call that's needed in the isExtend case, since really that step should be charged as part of the time needed for the extension operation. (This makes it slightly harder to match the read_start with the associated read_done, since now you can't match them on blockNumber, but it should still be possible since isExtend operations on the same relation can never be interleaved.) Per recent discussion. In passing, add the page identity (forkNum/blockNum) to the parameters of the buffer_flush_start/buffer_flush_done probes, which were unaccountably lacking the info.
- More fixes for 8.4 DTrace probes. Remove useless BUFFER_HIT/BUFFER_MISS probes --- the BUFFER_READ_DONE probe provides the same information and more besides. Expand the LOCK_WAIT_START/DONE probe arguments so that there's actually some chance of telling what is being waited for. Update and clean up the documentation.
Heikki Linnakangas a commité :
- In pgsql/src/backend/postmaster, fix Windows-specific race condition in syslogger. This could've been the cause of the "could not write to log file: Bad file descriptor" errors reported at
http://archives.postgresql.org//pgsql-general/2008-06/msg00193.php Backpatch to 8.3, the race condition was introduced by the CSV logging patch. Analysis and patch by Gurjeet Singh.
- Add seven kanji characters defined in the Windows 950 codepage to our big5/win950 <-> UTF8 conversion tables. Per report by Roger Chang.
- Fix case of the just resurrected UCS_to_BIG5.pl script, and update Makefile to use it.
- In pgsql/contrib/pg_standby/pg_standby.c, don't intercept SIGQUIT as a signal to trigger failover; that's what postmaster uses for immediate shutdown. Trap SIGUSR1 as the preferred signal for that. Per report by Fujii Masao and subsequent discussion on -hackers.
- In pgsql/contrib/pg_standby/pg_standby.c, don't set the signal handler for SIGQUIT on Windows. Buildfarm shows that reinstalling the default signal handler doesn't work as it is on Windows. Presumably core dumps on SIGQUIT are not a problem on Windows, so rather than figure out what header files or other changes are required to make it work, just don't bother.
Correctifs rejetés (à ce jour)
- Pas de déception cette semaine :-)
Correctifs en attente
- Koichi Suzuki sent in another revision of the PITR performance improvement patch.
- Magnus Hagander sent in a patch which changes the path separator for files on windows to a backslash unconditionally.
- Teodor Sigaev sent in another revision of the patch to add B-Tree emulation to GIN indexes.
- Shrish Purohit sent in another revision of the Thick Index patch.
- Michael Renner sent in a doc patch to clarify between redo and checkpoint records.
- Pavel Stehule sent in a WIP patch to add transformationHook.
- Sergey Burladyan sent in a patch to check for ngettext in configure, add some new macros for ngettext, and change psql's "(1 row)" messages to _P(...) macros.
- Tom Lane sent in a patch which fixes some libxml incompatibilities.