Features Download
From: David Fetter <david <at> fetter.org>
Subject: == PostgreSQL Weekly News - October 06 2013 ==
Newsgroups: gmane.comp.db.postgresql.announce
Date: Monday 7th October 2013 05:21:57 UTC (over 4 years ago)
== PostgreSQL Weekly News - October 06 2013 ==

The international CfP for Ecudorian PostgreSQL Day, part of the
International Meeting of Free Software in Quito, Ecuador, is open.
Write ecpug  postgresql  org.  Details (Spanish language)

== PostgreSQL Jobs for October ==


== PostgreSQL Local ==

The Italian PGDay (PGDay.IT) will be held on October the 25th in
Prato, Tuscany, Italy, at Monash University Center.
To register to the event or get information about the accepted talks
and schedule please see the official web site: http://2013.pgday.it

The PostgreSQL Conference China for 2013 will be held October 26-27,
2013 in Hangzhou.  Chinese language information here:

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

PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen.  The CfP is open through September
15, 2013.

The fourth edition of the Argentinian PostgreSQL Day will be held on
November 14 2013 in Buenos Aires, Argentina.  The CfP deadline is
September 28th, 2013.

PGDay Cuba will be in November, 2013.

== 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 [email protected], German language
to [email protected], Italian language to [email protected]  Spanish language
to [email protected]

== Applied Patches ==

Heikki Linnakangas pushed:

- Fix snapshot leak if lo_open called on non-existent object.  lo_open
  registers the currently active snapshot, and checks if the large
  object exists after that. Normally, snapshots registered by lo_open
  are unregistered at end of transaction when the lo descriptor is
  closed, but if we error out before the lo descriptor is added to the
  list of open descriptors, it is leaked. Fix by moving the snapshot
  registration to after checking if the large object exists.  Reported
  by Pavel Stehule. Backpatch to 8.4. The snapshot registration system
  was introduced in 8.4, so prior versions are not affected (and not
  supported, anyway).

- In bms_add_member(), use repalloc() if the bms needs to be enlarged.
  Previously bms_add_member() would palloc a whole-new copy of the
  existing set, copy the words, and pfree the old one. repalloc() is
  potentially much faster, and more importantly, this is less
  surprising if CurrentMemoryContext is not the same as the context
  the old set is in. bms_add_member() still allocates a new bitmapset
  in CurrentMemoryContext if NULL is passed as argument, but that is a
  lot less likely to induce bugs.  Nicholas White.

- Minor GIN code refactoring.  It makes for cleaner code to have
  separate Get/Add functions for PostingItems and ItemPointers.  A few
  callsites that have to deal with both types need to be duplicated
  because of this, but all the callers have to know which one they're
  dealing with anyway. Overall, this reduces the amount of casting
  required.  Extracted from Alexander Korotkov's larger patch to
  change the data page format.

Andrew Dunstan pushed:

- Ensure installation dirs are built before contents are installed
  (v2).  Push dependency on installdirs down to individual targets.
  Christoph Berg

- Add missing condition for pg_depend in hstore migration script.
  Error noted by Andres Freund.

- Document support for VPATH builds of extensions.  Cédric Villemain
  and me.

Alvaro Herrera pushed:

- Remove broken PGXS code for pg_xlogdump.  With the PGXS boilerplate
  in place, pg_xlogdump currently fails with an ominous error message
  that certain targets cannot be built because certain files do not
  exist.  Remove that and instead throw a quick error message alerting
  the user of the actual problem, which should be easier to diagnose
  that the statu quo.  Andres Freund

- Add WaitForLockers in lmgr, refactoring index.c code.  This is in
  support of a future REINDEX CONCURRENTLY feature.  Michael Paquier

- Make some isolationtester specs more complete.  Also, make sure they
  pass on all transaction isolation levels.

- isolationtester: Allow tuples to be returned in more places.
  Previously, isolationtester would forbid returning tuples in
  session-specific teardown (but not global teardown), as well as in
  global setup.  Allow these places to return tuples, too.

- add multixact-no-deadlock to schedule

- Fix various bugs in postmaster SIGKILL processing.  Clamp the
  minimum sleep time during immediate shutdown or crash to a minimum
  of zero, not a maximum of one second.  The previous code could
  result in a negative sleep time, leading to failure in select()
  calls.  Also, on crash recovery, reset AbortStartTime as soon as
  SIGKILL is sent or abort processing has commenced instead of waiting
  until the startup process completes.  Reset AbortStartTime as soon
  as SIGKILL is sent, too, to avoid doing that repeatedly.  Per
  trouble report from Jeff Janes on
  [email protected]om
  Author: MauMau

Bruce Momjian pushed:

- Adjust C comments that would be wrap-able.

- doc: fix hstore_to_json_loose() doc wording

- Issue error on SET outside transaction block in some cases.  Issue
  error for SET LOCAL/CONSTRAINTS/TRANSACTION outside a transaction
  block, as they have no effect.  Per suggestion from Morten Hustveit

- pg_upgrade doc: link mode additions.  Mention that link mode uses
  less disk space, and uses junction points on Windows.  Backpatch to

Magnus Hagander pushed:

- Fix copy/paste error

Peter Eisentraut pushed:

- psql: Set up cancel handler later.  The cancel handler was uselessly
  set up even before the first connection was opened.  By setting it
  up afterwards, the user can use Ctrl+C to abort psql if the initial
  connection attempt hangs.  Reviewed-by: Dean Rasheed
   Reviewed-by: Ryan Kelly

- doc: Correct psycopg URL

Robert Haas pushed:

- psql: Make \pset without arguments show all settings.  Gilles
  Darold, reviewed by Pavel Stehule

- Add DISCARD SEQUENCES command.  DISCARD ALL will now discard cached
  sequence information, as well.  Fabrízio de Royes Mello, reviewed by
  Zoltán Böszörményi, with some further tweaks by me.

- Fix silly thinko in ResetSequenceCaches.  Report from Kevin Hale

- doc: Add missing words to bgworker docs.  Maciek Sakrejda

Noah Misch pushed:

- pgbench: Elaborate latency reporting.  Isolate transaction latency
  (elapsed time between submitting first command and receiving
  response to last command) from client-side delays pertaining to the
  --rate schedule.  Under --rate, report schedule lag as defined in
  the documentation.  Report latency standard deviation whenever we
  collect the measurements to do so.  All of these changes affect
  --progress messages and the final report.  Fabien COELHO, reviewed
  by Pavel Stehule.

- pgbench: Remove stray use of "float" math.  Oversight in commit
  4a87f308b33457670f9ab4bc622678e5d285b9c2.  Fabien COELHO

- pgbench: Comment on thread timing hazards.  Reviewed by Fabien

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

David Rowley sent in a patch to use AppendStringInfo[type] functions
instead of bare AppendStringInfo in various places throughout the
source code.

Amit Kapila sent in another revision of a patch to implement ALTER

Nicholas White sent in two more revisions of a patch to implement
RESPECT/IGNORE NULLS in the LEAD and LAG window functions.

Andres Freund sent another flock of patches intended to be
infrastructure for logical changeset extraction and replay.

Pavel Stehule sent in a patch atop the one for \pset which makes
autocomplete work better.

Heikki Linnakangas sent in another revision of a patch to implement
UNNEST with multiple arguments and TABLE with multiple functions.

Michael Paquier sent in another revision of a patch to implement

Peter Eisentraut sent in another revision of a patch to use asprintf()
where available.

Oskari Saarenmaa sent in a patch to add file cloning using BTRFS tools
as an alternative data transfer method to pg_upgrade.

Rushabh Lathia sent in another revision of a patch to have INSERT et
al throw an error when a year field has length greater than 4 for the
timestamptz data type.

Kevin Grittner sent in three more revisions of a patch to fix an SSI
freezing bug.

Sawada Masahiko sent in another revision of a patch to allow fail-back
without a fresh backup.

Pavel Stehule sent in two revisions of a patch to optimize updates to
fixed-length arrays.

KaiGai Kohei sent in another revision of a patch to insert machinery
and examples for custom plan nodes.

Sameer Thakur sent in another revision of a patch to extend

David Rowley sent in another revision of a patch to ensure that his
previous patch to ensure that space reserved for WAL matches what is
written doesn't break on 32-bit machines.

David Rowley sent in two revisions of a patch to improve performance
of the column-wise INSERTs option in pg_dump.

Heikki Linnakangas sent in another revision of a patch to improve GIN
index performance by adding more information to the index.

Marko (johto) Tiikkaja sent in another revision of a patch to add a
plpgsql.print_strict_params GUC and associated machinery.

Noah Misch sent in a documentation patch to hold a place in pgbench
for fixing an issue where estimation and short runs can be noticeably

Sent via pgsql-announce mailing list ([email protected])
To make changes to your subscription:
CD: 4ms