== Wöchentlicher PostgreSQL Newsletter - 31. Juli 2011 ==

== Wöchentlicher PostgreSQL Newsletter - 31. Juli 2011 ==

am 01.08.2011 22:11:04 von adsmail

Der Originalartikel befindet sich unter:


== Wöchentlicher PostgreSQL Newsletter - 31. Juli 2011 ==

== PostgreSQL Produkt Neuigkeiten ==

Database Master 4, ein GUI Management und Reporting Werkzeug,
welches PostgreSQL unterstützt, ist erschienen.

ODB 1.5.0, ein ORM für C++, unterstützt PostgreSQL.
http://www.codesynthesis.com/~boris/blog/2011/07/26/odb-1-5- 0-released/

pgfincore 1.0, ein Set von Funktionen um das Low-Level Management von
Relationen, unter Zuhilfenahme von mincore, zu handhaben und um
den Cache Memory zu erforschen, ist erschienen.

Slony-I 2.0.7, eine eine kaskadierende Master-Slave
Replikationslösung für PostgreSQL, ist erschienen.

Version 1.19.3 von tail_n_mail, ein Programm zum Überwachen von
Logdateien, ist erschienen.

Version 4.4.6 von Bucardo, einem Postgres Multi-Master
Replikationssystem, ist erschienen.

== PostgreSQL Jobs im Juli ==

http://archives.postgresql.org/pgsql-jobs/2011-07/threads.ph p

== PostgreSQL Lokal ==

PGDay Porto Alegre findet am 19. August 19 2011
in Porto Alegre, RS, Brasilien statt.

Postgres Open 2011, eine Konferenz die sich auf den Umbruch der
Datenbankindustrie durch PostgreSQL konzentriert, wird vom 14. bis 16.
September 2011 in Chicago, Illinois im Westin Michigan Avenue
Hotel stattfinden.

PG-Day Denver 2011 findet am Freitag, dem 21. Oktober 2011 auf dem
Auraria Campus in der Nähe von Downtown Denver, Colorado statt.

PostgreSQL Conference West (#PgWest) findet vom 27. bis 30. September
2011 im San Jose Convention Center in Jan Jose, Kalifornen, USA statt.

PostgreSQL Conference Europe 2011 findet vom 18. bis
21. Oktober in Amsterdam statt.

pgbr findet in Sao Paulo, Brazilien, am 3. und 4. November 2011 statt.

PGConf.DE 2011 ist die Deutschsprachige PostgreSQL Konferenz
und wird am 11. November 2011 im Rheinischen Industriemuseum
in Oberhausen, Deutschland, stattfinden. Der Call for Papers ist offen.

== PostgreSQL in den News ==

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

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fet=

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david@fetter.org, deutsche an
pwn@pgug.de, italienische an pwn@itpug.org, spanische an pwn@arpug.com.ar.

== Reviews ==

== Angewandte Patches ==

Robert Haas pushed:

- Add new pgbench switch, --unlogged-tables. This entails adjusting
pgbench to use getopt_long() rather than getopt().
http://git.postgresql.org/pg/commitdiff/2d6fee09eba8474d9a69 c08bf716f3e2d31=

- Add new pgbench options, --tablespace and --index-tablespace. Per a
request from Greg Smith.
http://git.postgresql.org/pg/commitdiff/7c26395661ce549621db 6fa93c0abb9cdba=

- Improvements to SQL/MED documentation. Laurenz Albe, somewhat
modified by me.
http://git.postgresql.org/pg/commitdiff/f5af8eed9201e50bc5c7 61809ff57ef1ace=

- Add some environment checks prior to sepgsql regression testing.
This probably needs more work, but it's a start. KaiGai Kohei
http://git.postgresql.org/pg/commitdiff/8cca49d8a0d969e1c0f0 8779e8230466e39=

- Clarify which relkinds accept column comments. Per discussion with
Josh Kupershmidt.
http://git.postgresql.org/pg/commitdiff/c80be8a816ac4bf8b910 aaaec599c683804=

- Only display column comments for relkinds that support them. Josh
Kupershmidt, with minor modifications by me.
http://git.postgresql.org/pg/commitdiff/8c18f3f0e15738633231 b31d8937b2710b3=

- Fix typo. Noted by Josh Kupershmidt.
http://git.postgresql.org/pg/commitdiff/a8302803ab225e874580 37b922aceee9864=

- Move new pgbench options to correct section of --help output.
http://git.postgresql.org/pg/commitdiff/60fb25a3f56bd78e961c c7263e5ae11e1ec=

- Reduce sinval synchronization overhead. Testing shows that the
overhead of acquiring and releasing SInvalReadLock and msgNumLock on
high-core count boxes can waste a lot of CPU time and hurt
performance. This patch adds a per-backend flag that allows us to
skip all that locking in most cases. Further testing shows that
this improves performance even when sinval traffic is very high.
Patch by me. Review and testing by Noah Misch.
http://git.postgresql.org/pg/commitdiff/b4fbe392f8ff6ff1a66b 488eb7197eef9e1=

Andrew Dunstan pushed:

- Silence compiler warning about uninitialized variable. It is set
correctly on the only path that uses it, but the compiler can't know
http://git.postgresql.org/pg/commitdiff/74e6d37276564d4be1f6 0d9edb76d7d0663=

- Don't build replacement getpeereid function on mingw. Windows
doesn't have Unix sockets, so it's not needed, and moreover causes
compile warnings.
http://git.postgresql.org/pg/commitdiff/c9737310d5f9b87b5edb 3674b5d34eea2f1=

Peter Eisentraut pushed:

- Replace printf format %i by %d. They are identical, but the
overwhelming majority of the code uses %d, so standardize on that.
http://git.postgresql.org/pg/commitdiff/ce8d7bb6440710058503 d213b2aafcdf56a=

- Add missing newlines at end of error messages
http://git.postgresql.org/pg/commitdiff/e67efb01e886d69d40d1 cd87fba4507e8bb=

- Minor message style adjustment
http://git.postgresql.org/pg/commitdiff/0fe8150827693fca429a 01b1cf2914f7f14=

- Add host name resolution information to pg_hba.conf error messages.
This is to be able to analyze issues with host names in pg_hba.conf.
http://git.postgresql.org/pg/commitdiff/8a0fa9cad9939f53f0b4 96d95d7e7fd9cfa=

Tom Lane pushed:

- Check to see whether libxml2 handles error context the way we
expect. It turns out to be possible to link against a libxml2.so
that does this differently than the version we configured and built
against, so we need a runtime check to avoid bizarre behavior. Per
report from Bernd Helmle. Patch by Florian Pflug.
http://git.postgresql.org/pg/commitdiff/c1420fcf7d9e899b3378 e25f5e21776f646=

- Fix pg_restore's direct-to-database mode for
standard_conforming_strings. pg_backup_db.c contained a mini SQL
lexer with which it tried to identify boundaries between SQL
commands, but that code was not designed to cope with
standard_conforming_strings, and would get the wrong answer if a
backslash immediately precedes a closing single quote in such a
string, as per report from Julian Mehnle. The bug only affects
direct-to-database restores from archive files made with
standard_conforming_strings =3D on. Rather than complicating the code
some more to try to fix that, let's just rip it all out. The only
reason it was needed was to cope with COPY data embedded into
ordinary archive entries, which was a layout that was used only for
about the first three weeks of the archive format's existence, and
never in any production release of pg_dump. Instead, just rely on
the archive file layout to tell us whether we're printing COPY data
or not. This bug represents a data corruption hazard in all
releases in which standard_conforming_strings can be turned on, ie
8.2 and later, so back-patch to all supported branches.
http://git.postgresql.org/pg/commitdiff/6545a901aaf84cb05212 bb6a7674059908f=

Bruce Momjian pushed:

- Fix pg_update to properly test for the data directory's existence on
Win32. Backpatch to 9.1.
http://git.postgresql.org/pg/commitdiff/a31dc392d684627d0943 fe67491bea91c5e=

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Timothy D. F. Lewis sent in another revision of a patch which allows
people to set the maximum number of large objects which can be

Alexey Klyukin sent in another revision of the patch intended to
validate configuration files.

Jeff Janes sent in a patch to allow running pgbench in
single-transaction mode.

Florian Pflug sent in another revision of a patch intended to fix a
failure mode in XML.

Heikki Linnakangas sent in another revision of the patch to build GiST
indexes faster.

Josh Kupershmidt sent in another revision of the patch to display
object comments in psql.

Aron Wieck sent in another revision of the vacuumlo patch.

Pavel Stehule sent in another revision of the patch to enhance error

Alvaro Herrera sent in another revision of the FOR KEY LOCK patch.

Robert Haas sent in another revision of the patch intended to reduce
the number of sinval calls.

Nikhil Sontakke sent in two revisions of a patch to allow CHECK
constraints to be only on parent tables in an inheritance (partition)

Alvaro Herrera sent in another revision of the patch to catalog NOT
NULL constraints.

Peter Geoghegan sent in another revision of the patch intended to
reduce power consumption when idle.

Andrew Dunstan sent in a patch to clean up PL/PythonU.

Shigeru HANADA sent in another revision of the patch to add per-column
options to foreign data wrappers.

Robert Haas sent in two revisions of a patch intended to reduce
internal contention in pgbench.

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

Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription: