== Wöchentlicher PostgreSQL Newsletter - 12. August 2007 ==

Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/index.php?/archives/131-PostgreSQL-Weekly-News-August-12-2007.html

== Wöchentlicher PostgreSQL Newsletter - 12. August 2007 ==

Der PostgreSQL Fond bei SPI Inc. dankt den folgenden Firmen für
die Unterstützung die unseren sehr professionellen Auftritt auf der
LinuxWorldExpo und der OSCON ermöglicht haben: Continuent,
Open Technology Group, Truviso, CommandPrompt, EnterpriseDB
und Once Technologies.

== PostgreSQL Produkt Neuigkeiten ==

EnterpriseDB Postgres erschienen.
http://www.enterprisedb.com/products/index.do

pgsnmpd 1.0 erschienen.
http://pgfoundry.org/projects/pgsnmpd/

SchemaCrawler 5.1 for PostgreSQL erschienen.
http://schemacrawler.sourceforge.net/

== PostgreSQL Jobs im August ==

http://archives.postgresql.org/pgsql-jobs/2007-08/threads.php

== PostgreSQL Lokal ==

== PostgreSQL in the News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

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(dot)

== Angewandte Patches ==

Neil Conway committed:

- Fix a gradual memory leak in ExecReScanAgg(). Because the
aggregation hash table is allocated in a child context of the agg
node's memory context, MemoryContextReset() will reset but *not*
delete the child context. Since ExecReScanAgg() proceeds to build a
new hash table from scratch (in a new sub-context), this results in
leaking the header for the previous memory context. Therefore, use
MemoryContextResetAndDeleteChildren() instead. Credit: My colleague
Sailesh Krishnamurthy at Truviso for isolating the cause of the
leak.

- Adjust the output of MemoryContextStats() so that the stats for a
child memory contexts is indented two spaces to the right of its
parent context. This should make it easier to deduce the memory
context hierarchy from the output of MemoryContextStats().

Magnus Hagander committed:

- In pgsql/doc/src/sgml/cvs.sgml, fix incorrect URI for cvs rsync

Tom Lane committed:

- Avoid memory leakage across successive calls of regexp_matches() or
regexp_split_to_table() within a single query. This is only a
partial solution, as it turns out that with enough matches per
string these functions can also tickle a repalloc() misbehavior.
But fixing that is a topic for a separate patch.

- Code review for regexp_matches/regexp_split patch. Refactor to
avoid assuming that cached compiled patterns will still be there
when the function is next called. Clean up looping logic, thereby
fixing bug identified by Pavel Stehule. Share setup code between
the two functions, add some comments, and avoid risky mixing of int
and size_t variables. Clean up the documentation a tad, and accept
all the flag characters mentioned in table 9-19 rather than just a
subset.

- Fix uninitialized-memory bug in plpython proargnames patch. Per bug
#3523

- Fix unintended change of output format for createlang/droplang -l.
Missed these uses of printQuery() in FETCH_COUNT patch a year ago
:-(. Per report from Tomoaki Sato.

- Fix search for SGML stylesheets to include the place where Gentoo
keeps them. Brendan Jurd

- Revise postmaster startup/shutdown logic to eliminate the problem
that a constant flow of new connection requests could prevent the
postmaster from completing a shutdown or crash restart. This is
done by labeling child processes that are "dead ends", that is, we
know that they were launched only to tell a client that it can't
connect. These processes are managed separately so that they don't
confuse us into thinking that we can't advance to the next stage of
a shutdown or restart sequence, until the very end where we must
wait for them to drain out so we can delete the shmem segment. Per
discussion of a misbehavior reported by Keaton Adams. Since this
code was baroque already, and my first attempt at fixing the problem
made it entirely impenetrable, I took the opportunity to rewrite it
in a state-machine style. That eliminates some duplicated code
sections and hopefully makes everything a bit clearer.

- Fix thinko in multi-autovac-workers code: validity checks made by
GUC assign hooks are supposed to be made whether doit is true or
not.

- Fix pg_restore to guard against unexpected EOF while reading an
archive file. Per report and partial patch from Chad Wagner.

- Adjust configure so that it sets CFLAGS properly for Intel's icc
even if the compiler is not defining __GNUC__. Per report from Dirk
Tilger that it is possible for icc to not do that.

- In pgsql/src/include/storage/s_lock.h, apparently icc doesn't always
define __ICC, and it's more correct to check for __INTEL_COMPILER.
Per report from Dirk Tilger. Not back-patched since I don't fully
trust it yet ...

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