== Wöchentlicher PostgreSQL Newsletter - 15. März 2009 ==

Der Originalartikel befindet sich unter:
http://www.postgresql.org/community/weeklynews/pwn20090315

== Wöchentlicher PostgreSQL Newsletter - 15. März 2009 ==

Bug Fix Releases 8.3.7, 8.2.13, 8.1.17, 8.0.21 und 7.4.25 erscheinen
demnächst. Fertigmachen zum Upgrade.

Neue Umfrage: Welche Programmiersprache nutzt du mit PostgreSQL?
www.postgresql.org/community

Viele Pgdays sind in Brasilien in Planung, unter anderem in Sao Paulo,
Porto Velho, Ji-Parana und Brasilia. Mehr Neuigkeiten gibt es hier
nächste Woche.

Devrim GUNDUZ hat ein weiteres Set mit Snapshot RPMs veröffentlicht.
Gehe hin und teste es :)
http://yum.pgsqlrpms.org/news-8.4devel-ready-for-testing.php

Die französische Webseite 01.net hat PostgreSQL als für immer beste
Open Source Datenbank gewählt.
http://www.01net.com/editorial/404090/postgresql-meilleure-base-de-donnees-open-source/

Bald gibt es PostgreSQL Videos!

== PostgreSQL Produkt Neuigkeiten ==

Jopr 2.2 Beta 1, eine Server Management und Monitoring Applikation, ist
erschienen.
http://pilhuhn.blogspot.com/2009/03/public-beta-of-jopr-22-released.html

pglesslog 1.2, ein Patch welcher die Größe der WALs rediziert, ist
erschienen.
http://pglesslog.projects.postgresql.org/

Skytools 2.1.9, ein Python-basierendes Replikationssystem, ist
erschienen.
http://pgfoundry.org/projects/skytools/

== PostgreSQL 8.4 Feature der Woche ==

pg_stat_user_functions. Dieser neue System View erlaubt einem
nachzuvollziehen, welche Funktionen wie oft aufgerufen wurden und
wieviel Zeit in den Funktionen verwendet wurde.

== PostgreSQL Tipp der Woche ==

Tipp der Woche: pg_fouine analysiert PostgreSQL Logdateien und summiert
die langsamsten Anfragen auf. Der aktuelle CVS-Code funktioniert sogar
mit kommaseparierten Logs.

== PostgreSQL Jobs im März ==

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

== PostgreSQL Lokal ==

Die Deutsche PostgreSQL User Gruppe wird einen Stand, 2 Vorträge und
einen Workshop auf den Chemnitzer Linuxtagen am 14. und 15. März 2009
haben. Mehr Informationen auf Deutsch hier:
http://andreas.scherbaum.la/blog/archives/525-PostgreSQL-auf-den-Chemnitzer-Linuxtagen.html

PostgreSQLFr wird einen Stand auf der Solutions Linux 2009 in Paris
haben. Anmelden unter sas AT postgresql DOT fr oder im
französischen Wiki.
http://postgresql.fr/sl2009:start

Die Registrierung für die PostgreSQL Konferenz (JDCon) East 2009
ist jetzt möglich:
http://www.postgresql.us/purchase

Kevin Kempter wird über Backup und Wiederherstellen auf dem ersten
Denver PUG Meeting am 8. April 2009 sprechen.
http://www.diapug.org/Meeting.html

PostgreSQL Conference U.S. wird einen PgDay auf dem Linuxfest Nordwest
am 25. und 26. April veranstalten. Der Call for Papers ist unter:
http://www.postgresqlconference.org/

Michael Renner wird einen Workshop über PostgreSQL Replikation auf
der Netways OSDC 2009 in Nürnbern, Deutschland geben.
http://www.netways.de/english/osdc/y2009/programm/w/michael_renner_postgresql_repliziert_ein_ueberblick/

PGCon 2009 wird vom 21. bis 22. Mai 2009 in Ottawa an der Universität
von Ottawa stattfinden. Dem gehen zwei Tage mit Tutorials vom 19. bis
20. Mai 2009 voraus.
http://www.pgcon.org/2009/

Termin vormerken: pgDay San Jose, am Sonntag dem 19. Juli unmittelbar
vor der OSCON. CfP und mehr Informationen bald.

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden.

== PostgreSQL in den News ==

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

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Josh Berkus.

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Bruce Momjian committed:

- 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 committed:

- 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 committed:

- 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 committed:

- 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 committed:

- 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 committed:

- 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 committed:

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

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

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.

--
Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group: http://www.pgug.de
DPWN: http://andreas.scherbaum.la/blog/categories/18-PWN