== PostgreSQL Weekly News - September 01 2013 == - Mailing list pgsql-announce

== 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@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.  Spanish language
to pwn@arpug.com.ar.

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