== PostgreSQL Weekly News - September 01 2013 ==

== PostgreSQL Weekly News - September 01 2013 ==

Open Source Software for Business" (OSS4B) 2013 will be held in Prato,
Tuscany, Italy on September 19 and 20. Registration is open.
http://www.oss4b.it/

== PostgreSQL Product News ==

Mimeo 1.0.0, a logical replication extension that provides multiple
methods of replication with minimal setup and privileges, released.
https://github.com/omniti-labs/mimeo

== PostgreSQL Jobs for September ==

http://archives.postgresql.org/pgsql-jobs/2013-09/threads.php

== PostgreSQL Local ==

Postgres Open 2013 will be in Chicago, IL, USA, September 16-18.
The list of talks has been posted on the site.
http://postgresopen.org/

The PostgreSQL Conference China for 2013 will be held October 26-27,
2013 in Hangzhou. Chinese language information here:
https://wiki.postgresql.org/wiki/Pgconf_cn2013
Registration:
http://bbs.pgsqldb.com/client/bm.php

The Italian PGDay (PGDay.IT) will be held on October the 25th in
Prato, Tuscany, Italy, at Monash University Center.
The International Call For Papers is open:
http://2013.pgday.it/index.php/programma/call-for-papers-english/

pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel
in downtown Dublin, Ireland. Registration is open.
http://2013.pgconf.eu/

PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen. The CfP is open through September
15, 2013.
http://2013.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(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot) Spanish language
to pwn(at)arpug(dot)com(dot)ar(dot)

== Applied Patches ==

Robert Haas pushed:

- doc: Explain that ereport doesn't return for ERROR or higher levels.
Christophe Pettus
http://git.postgresql.org/pg/commitdiff/8d00ab630668a15e86b584b39187ef3bf3154511

- Partially restore comments discussing enum renumbering hazards. As
noted by Tom Lane, commit 813fb0315587d32e3b77af1051a0ef517d187763
was overly optimistic about how safe it is to concurrently change
enumsortorder values under MVCC catalog scan semantics. Restore
some of the previous text, with hopefully-correct adjustments for
the new state of play.
http://git.postgresql.org/pg/commitdiff/c9e2e2db5c2090a880028fd8c1debff474640f50

- Allow discovery of whether a dynamic background worker is running.
Using the infrastructure provided by this patch, it's possible
either to wait for the startup of a dynamically-registered
background worker, or to poll the status of such a worker without
waiting. In either case, the current PID of the worker process can
also be obtained. As usual, worker_spi is updated to demonstrate
the new functionality. Patch by me. Review by Andres Freund.
http://git.postgresql.org/pg/commitdiff/090d0f2050647958865cb495dff74af7257d2bb4

Alvaro Herrera pushed:

- Fix some "translator:" comments mangled by pgindent
http://git.postgresql.org/pg/commitdiff/673b527534893a4a8adb3cdef52fc645c13598ce

- Initialize cached OID to Invalid in new hash entries. Andres
Freund; bug detected by valgrind
http://git.postgresql.org/pg/commitdiff/e246cfc95f020b5fcb20a1fb946efe77113edf00

- Make error wording more consistent
http://git.postgresql.org/pg/commitdiff/9381cb5229da1f3556909585b38ada347d798161

Heikki Linnakangas pushed:

- Accept multiple -I, -P, -T and -n options in pg_restore. We already
did this for -t (--table) in 9.3, but missed the other similar
options. For consistency, allow all of them to be specified multiple
times. Unfortunately it's too late to sneak this into 9.3, so
commit to master only.
http://git.postgresql.org/pg/commitdiff/da85fb4747ac0b7f787ef7a402adea2747e32d8e

- Use a non-locking initial test in TAS_SPIN on x86_64. Testing done
in 2011 by Tom Lane concluded that this is a win on Intel Xeons and
AMD Opterons, but it was not changed back then, because of an old
comment in tas() that suggested that it's a huge loss on older
Opterons. However, didn't have separate TAS() and TAS_SPIN() macros
back then, so the comment referred to doing a non-locked initial
test even on the first access, in uncontended case. I don't have
access to older Opterons, but I'm pretty sure that doing an initial
unlocked test is unlikely to be a loss while spinning, even though
it might be for the first access. We probably should do the same on
32-bit x86, but I'm afraid of changing it without any testing. Hence
just add a note to the x86 implementation suggesting that we
probably should do the same there.
http://git.postgresql.org/pg/commitdiff/b03d196be055450c7260749f17347c2d066b4254

Tom Lane pushed:

- Reset the binary heap in MergeAppend rescans. Failing to do so can
cause queries to return wrong data, error out or crash. This
requires adding a new binaryheap_reset() method to binaryheap.c, but
that probably should have been there anyway. Per bug #8410 from
Terje Elde. Diagnosis and patch by Andres Freund.
http://git.postgresql.org/pg/commitdiff/8e2b71d2d0381f7acc820a2400580a1e3a6add8c

- Add test case for bug #8410. Per Andres Freund.
http://git.postgresql.org/pg/commitdiff/ac2d0e464aef5bbef1308abf0154986b3982714d

- Improve regression test for #8410. The previous version of the
query disregarded the result of the MergeAppend instead of checking
its results. Andres Freund
http://git.postgresql.org/pg/commitdiff/abd3f8ca4b84707adba2e6d69413c724715cceb3

- Update 9.3 release notes. Some corrections, a lot of copy-editing.
Set projected release date as 2013-09-09.
http://git.postgresql.org/pg/commitdiff/f49f8de074c37d7af5441f79e5569b9e463d0b09

- Update "Using EXPLAIN" documentation examples using current code.
It seems like a good idea to update these examples since some fairly
basic planner behaviors have changed in 9.3; notably that the
startup cost for an indexscan plan node is no longer invariably
estimated at 0.00.
http://git.postgresql.org/pg/commitdiff/244c8b466a743d1ec18a7d841bf42669699b3b56

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

David Rowley and Vik Fearing traded patches to allow formatting in
log_line_prefix.

Tarvi Pillessaar sent in another revision of a patch to add detail
part for the "process x is still waiting for" lock message to show
information about the lock holder and also show what the lock holder
is actually doing.

Andrew (RhodiumToad) Gierth sent in another revision of a patch to add
UNNEST with multiple arguments and TABLE with multiple functions.

Pavel Stehule sent in another revision of a patch to improve NUMERIC
performance.

Michael Paquier sent in another revision of a patch to implement
REINDEX CONCURRENTLY.

Heikki Linnakangas sent a trio of patches to: separate pg_dump -E
from PGCLIENTENCODING, set client_encoding='auto' in all the client
utilities, as already done in psql, and use iconv(3) in pg_restore to
do encoding conversion in the client.

Alvaro Herrera sent in a patch to move src/port/pgcheckdir.c to
src/common/checkdir.c and add the shareable part of postmaster's
current checkDataDir code into it, as pg_check_dir_permissions.

Andres Freund sent in a patch to error out when building pg_xlogdump
with PGXS.

Dimitri Fontaine sent in three more revisions of a patch to implement
extension templates.

Heikki Linnakangas sent in another revision of a patch to allow
freezing without write I/O.

KaiGai Kohei sent in another revision of a patch to implement
row-level access controls.

Sawada Masahiko sent in another revision of a patch to fix synchronous
standby priorities.

MauMau sent in another revision of a patch to clarify which versions
of Solaris are supported.

Wang Shuo sent in a patch to allow disabling constraints by name and
re-enabling them later.

Fujii Masao sent in a patch to allow compressing certain full-page
writes.

KONDO Mitsumasa sent in a patch to add an option to pgbench which
would checkpoint before starting the benchmark.

Andres Freund sent in more revisions of patches which are
infrastructure for logical replication.

Tom Lane sent in a patch to enable variadic aggregates.

Peter Geoghegan sent in a patch to enable INSERT...ON DUPLICATE KEY
IGNORE, and there was much rejoicing.

Stefan Kaltenbrunner sent in a patch to add an elevel argument to
ProcessGUCArray and then call it with NOTICE in the case that
check_function_bodies is true.

Jeff Janes sent in a patch to add the disable cost to the cost of
materializing the inner scan when materialization is disabled.