== PostgreSQL Weekly News - July 31 2011 ==

== PostgreSQL Weekly News - July 31 2011 ==

== PostgreSQL Product News ==

Database Master 4, a GUI management and reporting tool which supports
PostgreSQL, released.
http://www.nucleonsoftware.com/

ODB 1.5.0, an ORM for C++, supports PostgreSQL.
http://www.codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/
                                     

pgfincore, 1.0, a set of functions to handle low-level management of
relations using mincore to explore cache memory, released.
http://pgfoundry.org/projects/pgfincore/

Slony-I 2.0.7, a master-to-multiple-cascading-replica system for
PostgreSQL, released.
http://www.slony.info/

Version 1.19.3 of tail_n_mail, a Postgres log watcher program, released.
http://bucardo.org/wiki/Tail_n_mail

Version 4.4.6 of Bucardo, a Postgres multi-master replication system, released.
http://bucardo.org/wiki/Bucardo

== PostgreSQL Jobs for July ==

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

== PostgreSQL Local ==

PGDay Porto Alegre will be on August 19, 2011 in Porto Alegre, RS, Brazil.
http://www.postgresql.org.br/eventos/2011/pgday/rs

Postgres Open 2011, a conference focused on disruption of the database
industry through PostgreSQL, will take place September 14-16, 2011 in
Chicago, Illinois at the Westin Michigan Avenue hotel.
http://postgresopen.org

PG-Day Denver 2011 will be held on Friday, October 21st, 2011 at
the Auraria Campus near downtown Denver, Colorado.
http://pgday.consistentstate.com/

PostgreSQL Conference West (#PgWest) will be held September 27th-30th,
2011 at the San Jose Convention center in San Jose, California, USA.
http://www.postgresqlconference.org

PostgreSQL Conference Europe 2011 will be held on October 18-21 in
Amsterdam.
http://2011.pgconf.eu/

pgbr will be in Sao Paulo, Brazil November 3-4, 2011.
http://pgbr.postgresql.org.br/

PGConf.DE 2011 is the German-speaking PostgreSQL Conference and will
take place on November 11th in the Rheinisches Industriemuseum in
Oberhausen, Germany.  Call for Papers is open.
http://2011.pgconf.de/

== PostgreSQL in the News ==

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

PostgreSQL Weekly News is brought to you this week by David Fetter

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.  Spanish language
to pwn@arpug.com.ar.

== Reviews ==

== Applied 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/2d6fee09eba8474d9a69c08bf716f3e2d31e5fdf

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

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

- 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/8cca49d8a0d969e1c0f08779e8230466e395b813

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

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

- Fix typo.  Noted by Josh Kupershmidt.
  http://git.postgresql.org/pg/commitdiff/a8302803ab225e87458037b922aceee9864d9f54

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

- 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/b4fbe392f8ff6ff1a66b488eb7197eef9e1770a4

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
  that.
  http://git.postgresql.org/pg/commitdiff/74e6d37276564d4be1f60d9edb76d7d066395773

- 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/c9737310d5f9b87b5edb3674b5d34eea2f198a0b

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/ce8d7bb6440710058503d213b2aafcdf56a5b481

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

- Minor message style adjustment
  http://git.postgresql.org/pg/commitdiff/0fe8150827693fca429a01b1cf2914f7f14d3b2d

- 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/8a0fa9cad9939f53f0b496d95d7e7fd9cfab0e9c

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/c1420fcf7d9e899b3378e25f5e21776f6461b4a4

- 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 = 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/6545a901aaf84cb05212bb6a7674059908f527c3

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/a31dc392d684627d0943fe67491bea91c5e619aa

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending 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
vacuumed.

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
reporting.

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)
hierarchy.

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.