PostgreSQL Weekly News – January 01 2012

== PostgreSQL Weekly News – January 01 2012 ==

Happy New Year from the PostgreSQL Weekly News!

== PostgreSQL Product News ==

AnyDAC for Delphi v 5.0.5 released.

psqlODBC 09.01.0100 released.

== PostgreSQL Local ==

The fifth annual “Prague PostgreSQL Developers Day” conference,
organized by CSPUG (Czech and Slovak PostgreSQL Users Group), will be
held on February 9, 2012 in Prague. The Call for Papers is open.
Please send proposals including contact information, topic, and
expected length of session to info AT p2d2 DOT cz.

The Call for Papers for is open for FLOSS UK, which will be held in
Edinburgh from the 20th to the 22nd March 2012. The deadline for
proposals is the 18th November 2011 and selected speakers will be
notified by the 25th November 2011. Proposals should be submitted to
postgresql2012 AT flossuk DOT org. More information at:

== PostgreSQL in the News ==

Planet PostgreSQL:

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, German language
to, Italian language to Spanish language

== Reviews ==

== Applied Patches ==

Alvaro Herrera pushed:

– Minor enhancements to MVCC chapter. Author: Erik Rijkers

Peter Eisentraut pushed:

– Sort file list when creating gettext-files. That way, the created
.pot file is more deterministic and not dependent on the order in
which the files are found.

– Sort compendium lists for msgmerge. That way, the result of a
msgmerge is more deterministic and not dependent on the order in
which the files are found.

– Run “make all” as a prerequisite of “make check”. This is the
standard behavior but was forgotten in some places.

– Remove support for on_exit(). All supported platforms support the
C89 standard function atexit() (SunOS 4 probably being the last one
not to), and supporting both makes the code clumsy.

– Standardize treatment of strcmp() return value. Always compare the
return value to 0, don’t use cute tricks like if (!strcmp(…)).

– Indicate default format in –help output of pg_dump and

– pg_dump: Dump user mappings ordered by user name This is to get a
deterministic dump order independent of the order in which the user
mappings were created.

– PL/Python: Add argument names to function declarations. For easier
source reading

Tom Lane pushed:

– Adjust SP-GiST regression tests to be less locale-sensitive. The
original test cases gave varying results depending on whether the
locale sorts digits before or after letters. Since that’s not
really what we wish to test here, adjust the test data to not
contain any strings beginning with digits. Per report from Pavel

– Revert “Remove troublesome Asserts in cost_mergejoin().” This
reverts commit ff68b256a533b398e3420750f34d161aeee4e099. The recent
change to use -fexcess-precision=standard should make those Asserts
safe, and does fix a test case that formerly crashed for me, so I
think there’s no need to have a cross-version difference in the code

– Use mutex hint bit in PPC LWARX instructions, where possible. The
hint bit makes for a small but measurable performance improvement in
access to contended spinlocks. On the other hand, some PPC chips
give an illegal-instruction failure. There doesn’t seem to be a
completely bulletproof way to tell whether the hint bit will cause
an illegal-instruction failure other than by trying it; but most if
not all 64-bit PPC machines should accept it, so follow the Linux
kernel’s lead and assume it’s okay to use it in 64-bit builds. Of
course we must also check whether the assembler accepts the command,
since even with a recent CPU the toolchain could be old. Patch by
Manabu Ori, significantly modified by me.

– Use 4-byte slock_t on both PPC and PPC64. Previously we defined
slock_t as 8 bytes on PPC64, but the TAS assembly code uses
word-wide operations regardless, so that the second word was just
wasted space. There doesn’t appear to be any performance benefit in
adding the second word, so get rid of it to simplify the code.

– Use LWSYNC in place of SYNC/ISYNC in PPC spinlocks, where possible.
This is allegedly a win, at least on some PPC implementations,
according to the PPC ISA documents. However, as with LWARX hints,
some PPC platforms give an illegal-instruction failure. Use the
same trick as before of assuming that PPC64 platforms will accept
it; we might need to refine that based on experience, but there are
other projects doing likewise according to google. I did not add an
assembler compatibility test because LWSYNC has been around much
longer than hint bits, and it seems unlikely that any toolchains
currently in use don’t recognize it.

Bruce Momjian pushed:

– Modify tools/pgtest to run the ‘make’ command from a variable, and
default to ‘make’ rather than ‘gmake’ for the binary name.

– Fix Perl copyright script to skip .git subdirectory; running it on
those files corrupts the index.

– Don’t use tabs in Perl scripts, for consistency.

– Update copyright notices for year 2012.

– Skip ‘ico’ and ‘bin’ extensions in copyright changes.

– Revert binary change in copyright year adjustment.

– Skip any .git directory for copyright changes, not just top-level
.git directories. Per suggestion from Andrew Dunstan.

– Update copyright git skip comment.

Simon Riggs pushed:

– Send new protocol keepalive messages to standby servers. Allows
streaming replication users to calculate transfer latency and apply
delay via internal functions. No external functions yet.

== Rejected Patches (for now) ==

No one was disappointed this week 🙂

== Pending Patches ==

Simon Riggs sent in two more revisions of the patch to add page checksums.

Alexander Björnhagen sent in two more revisions of the patch to tune
synchronous replication.

Brar Piening sent in two more revisions of the patches to support VS

Andrew Dunstan sent in another revision of the patch to make
pretty-printing view definitions actually print them in a pretty way.

Peter Eisentraut sent in a patch to fix an infelicity in CREATE TABLE

Peter Eisentraut sent in a patch to make the dumping of FOREIGN
… OPTIONS more legible.

Simon Riggs sent in another revision of the patch to pause at the end
of recovery.

Peter Geoghegan sent in another revision of the fast path sorting
patch, along with some benchmarks demonstrating its usefulness.

Simon Riggs sent in a patch to implement DROP INDEX CONCURRENTLY.

Noah Misch sent in a patch to add protransform functions to the length
coercions for numeric, varbit, timestamp, timestamptz, time, timetz
and interval. This prevents whole-table rewrites in some ALTER
TABLE … ALTER COLUMN … TYPE … statements involving the
aforementioned types.

Noah Misch sent in another revision of the patch to collect frequency
statistics for arrays.

Zoltan Boszormenyi sent in another revision of the patch to fix ECPG
cursor readahead.

Pavel Stehule sent in another revision of the CHECK FUNCTION patch.

Peter Eisentraut sent in a WIP patch intended to inform the
information schema about default privileges.

Peter Eisentraut sent in a WIP patch to relax the requirement that
PL/pgsql trigger functions return a value when called in AFTER

Peter Eisentraut sent in a patch to fix the sorting of operators in

Comments are closed.