Nouvelles hebdomadaires de PostgreSQL - 15 mars 2009

Correction de bug dans les versions 8.3.7, 8.2.13, 8.1.17, 8.0.21 et 7.4.25 à venir. Préparez-vous à mettre à jour. [ndt: versions disponibles ce jour]

Nouveau sondage : quel langage de programmation utilisez-vous avec PostgreSQL ? www.postgresql.org/community

De nombreux PgDays sont en train d'être organisés au Brésil, avec São Paulo, Porto Velho, Ji-Paraná et Brasilia. Plus d'informations la semaine prochaine !

Devrim GUNDUZ a publié un nouvel ensemble de paquets RPM de test. Lancez-vous et testez :) http://yum.pgsqlrpms.org/news-8.4devel-ready-for-testing.php

Le site 01.net a couronné PostgreSQL "meilleure base de données Open Source" : http://www.01net.com/editorial/404090/postgresql-meilleure-base-de-donnees-open-source/

Des vidéos liées à PostgreSQL bientôt disponibles !

Les nouveautés des produits dérivés

• Jopr 2.2 beta 1, un logiciel de gestion et de surveillance serveurs : http://pilhuhn.blogspot.com/2009/03/public-beta-of-jopr-22-released.html
• pglesslog 1.2, un patch permettant de réduire la taille des WALs : http://pglesslog.projects.postgresql.org/
• Skytools 2.1.9, un système de réplication en Python : http://pgfoundry.org/projects/skytools/

La fonctionnalité 8.4 de la semaine

pg_stat_user_functions : cette nouvelle vue système permet de voir quelles fonctions et combien de fois elles ont été appelées, ainsi que le temps écoulé dans la fonction et dans les appels effectués à l'intérieur de celle-ci.

L'astuce de la semaine

pg_fouine parcourt les logs de PostgreSQL et fait une synthèse des requêtes les plus lentes. La version en cours de développement est même capable de travailler sur des logs à virgules.

Offres d'emplois autour de PostgreSQL en mars

• http://archives.postgresql.org/pgsql-jobs/2009-03/threads.php

PostgreSQL Local

• Le PUG allemand tiendra une rencontre, deux conférences et un atelier lors des Linuxdays de Chemnitz les 14 & 15 mars 2009. Plus d'information ici (alld) : http://andreas.scherbaum.la/blog/archives/525-PostgreSQL-auf-den-Chemnitzer-Linuxtagen.html
• PostgreSQLFr tiendra un stand aux Solutions Linux 2009 à Paris. Volontaires : sas (a) postgresql (point) fr, ou sur le wiki : http://postgresql.fr/sl2009:start
• Les inscriptions pour la "PostgreSQL Conference (JDCon) East 2009" sont à présent ouvertes : http://www.postgresql.us/purchase
• Kevin Kempter fera une présentation des sauvegardes et des récupérations lors de la première réunion du PUG de Denver, le 8 avril 2009 : http://www.diapug.org/Meeting.html
• "PostgreSQL Conference, U.S." organise un PgDay lors de la "LinuxFest Northwest" (25 & 26 avril). L'appel aux conférences est visible à l'adresse : http://www.postgresqlconference.org/
• Michael Renner animera un atelier sur la réplication PostgreSQL lors des "Netways OSDC", les 29 et 30 avril 2009, à Nuremberg (All.) : http://www.netways.de/english/osdc/y2009/programm/w/michael_renner_postgresql_repliziert_ein_ueberblick/
• La PGCon 2009 se tiendra à l'Université d'Ottawa les 21 et 22 mai 2009. Elle sera précédée de deux jours de tutoriels les 19 & 20 mai : http://www.pgcon.org/2009/
• Notez la date : pgDay San Jose, dimanche 19 juillet juste avant l'OSCON. Appel à conférenciers, plus d'infos sous peu !
• La "PGCon Brazil" prendra place à l'Unicamp de Campinas (État de São Paulo) les 23 & 24 octobre 2009.

PostgreSQL dans les média

• Planet PostgreSQL : http://planet.postgresql.org/

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

Bruce Momjian a commité :

• In pgsql/src/backend/utils/time/tqual.c, add summarization comment about visibility functions. Add URL about the Halloween problem.
• In pgsql/doc/src/sgml/monitoring.sgml, doc patch for the recently added probes. Robert Lor

Peter Eisentraut a commité :

• Accept 'on' and 'off' as input for boolean data type, unifying the syntax that the data type and GUC accepts. ITAGAKI Takahiro
• Tweak the regression test case so that the ordering of numbers vs. letters doesn't matter. This fixes failures in the Czech locale.
• In pgsql/src/backend/utils/adt/bool.c, in parse_bool_with_len, avoid crash when no result pointer is passed. Probably an unlikely call mode, but better be safe.
• In pgsql/src/backend/po/ru.po, translation updates.

Teodor Sigaev a commité :

• In pgsql/src/backend/tsearch/wparser_def.c, prevent recursion during parse of email-like string with multiple '@'. Patch by Heikki Linnakangas.
• In pgsql/src/backend/tsearch/wparser_def.c, some languages have symbols with zero display's width or/and vowels/signs which are not an alphabetic character although they are not word-breakers too. So, treat them as part of word. Per off-list discussion with Dibyendra Hyoju and and Bal Krishna Bal about the Nepali language and Devanagari alphabet.

Tom Lane a commité :

• Fix set_subquery_pathlist() to copy the RTE's subquery before it gets mangled by the planning process. This prevents the "failed to locate grouping columns" error recently reported by Dickson Guedes. That happens because planning replaces SubLinks by SubPlans in the subquery's targetlist, and exprTypmod() is smarter about the former than the latter, causing the apparent type of the subquery's output columns to change. This seems to be a deficiency we should fix in exprTypmod(), but that will be a much more invasive patch with possible side-effects elsewhere, so I'll do that only in HEAD. Back-patch to 8.3. Arguably the lack of a copying step is broken/dangerous all the way back, but in the absence of known problems I'll refrain from making the older branches pay the extra cost. (The reason this particular symptom didn't appear before is that exprTypmod() wasn't smart about SubLinks either, until 8.3.)
• Make SubPlan nodes carry the result's typmod as well as datatype OID. This is for consistency with the (relatively) recent addition of typmod to SubLink. An example of why it's a good idea is to be seen in the recent "failed to locate grouping columns" bug, which wouldn't have happened if a SubPlan exposed the same typmod info as the SubLink it was derived from. This could be back-patched, since it doesn't affect any on-disk data format, but for the moment it doesn't seem necessary to do so.
• In pgsql/src/backend/optimizer/path/indxpath.c, improve match_special_index_operator() to recognize that LIKE with an exact-match pattern (no wildcard) can be index-optimized in some cases where a prefix-match pattern cannot; specifically, since the required index clause is simple equality, it works for regular text/varchar indexes even when the locale is not C. I'm not sure how often this case really comes up, but since it requires hardly any additional work to handle it, we might as well get it right. Motivated by a discussion on the JDBC list.
• Code review for dtrace probes added (so far) to 8.4. Adjust placement of some bufmgr probes, take out redundant and memory-leak-inducing path arguments to smgr__md__read__done and smgr__md__write__done, fix bogus attempt to recalculate space used in sort__done, clean up formatting in places where I'm not sure pgindent will do a nice job by itself.
• In pgsql/src/backend/utils/adt/formatting.c, fix core dump due to null-pointer dereference in to_char() when datetime format codes are misapplied to a numeric argument. (The code still produces a pretty bogus error message in such cases, but I'll settle for stopping the crash for now.) Per bug #4700 from Sergey Burladyan. Problem exists in all supported branches, so patch all the way back. In HEAD, also clean up some ugly coding in the nearby cache management code.
• In pgsql/doc/src/sgml/release.sgml, update back-branch release notes.
• In pgsql/src/backend/storage/buffer/bufmgr.c, restore previous ordering of BUFFER_FLUSH_START probe. I had wanted to make it include the time for the possible smgropen() call, but that results in a null pointer dereference :-( . An alternative solution would be to fetch the buffer tag instead of looking at *reln, but I'll just put it back as it was for the moment. BTW, this indicates that DTrace probes evaluate their arguments even when nominally inactive. What was that about "zero cost", again?
• In pgsql/src/bin/pg_dump/pg_backup_archiver.c, fix identify_locking_dependencies to reflect the fact that fix_dependencies previously repointed TABLE dependencies to TABLE DATA. Mea culpa.
• Clean up the code for to_timestamp's conversion of year plus ISO day number to date, as per bug #4702 and subsequent discussion. In particular, make it work for years specified using AD/BC or CC fields, and fix the test for "no year specified" so that it doesn't trigger inappropriately for 1 Bryce Cutt (which it was doing even in code paths that had nothing to do with to_timestamp). I also did some minor code beautification in the non-ISO-day-number code path. This area has been busted all along, but because the code has been rewritten repeatedly, it would be considerable trouble to back-patch. It's such a corner case that it doesn't seem worth the effort.
• Fix contrib/hstore to throw an error for keys or values that don't fit in its data structure, rather than silently truncating them. Andrew Gierth.

Alvaro Herrera a commité :

• Remove pg_trace.h inclusion from c.h and add it to the .c files that need it. Only needed in 8.3 because it's already this way in HEAD, and older branches did not support DTrace. This allows external modules to compile on Linux machines where SystemTap support was recently added, when the required SystemTap headers are not present on the build machine. Approach suggested by Tom Lane, after a RPM build trouble report by Devrim Gunduz.

Andrew Dunstan a commité :

• Use thread-local storage for querybuffer in fmtId() on Windows, when needed (i.e. when running pg_restore, which might run in parallel). Only reopen archive file when we really need to read from it, in parallel code. Otherwise, close it immediately in a worker, if possible.

Marc Fournier a commité :

• Tag 8.3.7, 8.2.13, 8.1.17, 8.0.21, and 7.4.25.

Correctifs rejetés (à ce jour)

• Pas de déceoption cette semaine :-)

Correctifs en attente

• KaiGai Kohei sent in three more revisions of his SE-PostgreSQL patches.
• Greg Sabino Mullane sent in a patch to remove the confusing -i and -d switches from pg_dump, leaving only the long forms of what they used to do.
• ITAGAKI Takahiro sent in two revisions of a sampling profiler for 8.5.
• Fujii Masao sent in another version of the PITR performance improvement patch.
• Alvaro Herrera sent in a patch to 8.3 which includes pg_trace.h only in files that actually need it.