Features Download
From: David Fetter <david <at> fetter.org>
Subject: == PostgreSQL Weekly News - June 23 2013 ==
Newsgroups: gmane.comp.db.postgresql.announce
Date: Monday 24th June 2013 02:29:14 UTC (over 3 years ago)
== PostgreSQL Weekly News - June 23 2013 ==

PGDay Italy will be in Prato, Tuscany on October 25, 2013.
Watch this space for more details.

== PostgreSQL Product News ==

pgBadger 3.4, a parallel PostgreSQL log analyzer written in Perl,

PG Commander, a PostgreSQL client for OS X, released.

PostGIS 2.1.0beta3, the industry standard geographic information
system for PostgreSQL, released.

psycopg2 2.5.1, a Python connector for PostgreSQL, released.

== PostgreSQL Jobs for June ==


== PostgreSQL Local ==

We're going to have a booth at OSCON this year.  Please sign up and
hang out at the booth for an hour or two:

PGDay UK 2013 is July 12, 2013.  Registration is open.

PostgreSQL Brazil will be held August 15-17, 2013 in Porto Velho, RO,

Postgres Open 2013 will be in Chicago, IL, USA, September 16-18.
Early Bird registration and call for presentations closes June 30th.

pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel
in downtown Dublin, Ireland.  The CfP 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.

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

Jeff Davis pushed:

- Add buffer_std flag to MarkBufferDirtyHint().  MarkBufferDirtyHint()
  writes WAL, and should know if it's got a standard buffer or not.
  Currently, the only callers where buffer_std is false are related to
  the FSM.  In passing, rename XLOG_HINT to XLOG_FPI, which is more
  descriptive.  Back-patch to 9.3.

Peter Eisentraut pushed:

- psql: Re-allow -1 together with -c or -l

- initdb: Add blank line before output about checksums.  This
  maintains the logical grouping of the output better.

- Further update CREATE FUNCTION documentation about argument names.
  More languages than SQL and PL/pgSQL actually support parameter

- Clarify terminology standalone backend vs. single-user mode.  Most
  of the documentation uses "single-user mode", so use that in the
  code as well.  Adjust the documentation to match the new error
  message wording.  Also add a documentation index entry for
  "single-user mode".  Based-on-patch-by: Jeff Janes.

- doc: Fix date in EPUB manifest.  If there is no  element, the
  publication date for the EPUB manifest is taken from the copyright
  year.  But something like "1996-2013" is not a legal date
  specification.  So the EPUB output currently fails epubcheck.  Put
  in a separate  element with the current year.  Put it in
  legal.sgml, because copyright.pl already instructs to update that
  manually, so it hopefully won't be missed.

Simon Riggs pushed:

- Fix docs on lock level for ALTER TABLE VALIDATE.  ALTER TABLE ..
  VALIDATE CONSTRAINT previously gave incorrect details about lock
  levels and therefore incomplete reasons to use the option.  Initial
  bug report and fix from Marko Tiikkaja Reworded by me to include
  comments by Kevin Grittner

- Ensure no xid gaps during Hot Standby startup.  In some cases with
  higher numbers of subtransactions it was possible for us to
  incorrectly initialize subtrans leading to complaints of missing
  pages.  Bug report by Sergey Konoplev.  Analysis and fix by Andres

Kevin Grittner pushed:

- Fix the create_index regression test for Danish collation.  In
  Danish collations, there are letter combinations which sort higher
  than 'Z'.  A test for values > 'WA' was picking up rows where the
  value started with 'Ants Aasma', causing the test to fail.
  Backpatch to 9.2, where the failing test was added.  Per report from
  Svenne Krap and analysis by Jeff Janes

Bruce Momjian pushed:

- Modernize entab source code.  Remove halt.c, improve comments,
  rename manual page file.

Fujii Masao pushed:

- Support TB (terabyte) memory unit in GUC variables.  Patch by Simon
  Riggs, reviewed by Jeff Janes and me.

Tom Lane pushed:

- Add a comment warning against use of pg_usleep() for long sleeps.
  Follow-up to commit 873ab97219caabeb2f7b390268a4fe01e2b7518c, in
  which I noted that WaitLatch was a better solution in the commit log
  message, but neglected to add any documentation in the code.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

David Fetter sent in another revision of a patch to implement

Andres Freund sent in a patch to clarify an error message on Linux.

Robins Tharakan sent in another revision of a patch to add regression
tests for SET xxx.

Alexander Korotkov sent in two more revisions of a patch to add more
information to GIN indexes.

Alexander Korotkov sent in two more revisions of a patch to add
ordering in GIN indexes.

Alexander Korotkov sent in two more revisions of a patch to add fast
scan to GIN indexes.

Ian Link sent in a patch to improve the fast GIN cache.

Michael Paquier sent in five more revisions of a patch to implement

Jeff Davis sent in another revision of a patch to have pg_filedump
take checksums, among other things, into account.

Amit Langote sent in a patch to correct a comment in heaptuple.c.

Cedric Villemain sent in a patch to fix a bug and add new features to

Etsuro Fujita sent in four more revisions of a patch to remove unused

Nicholas White and Troels Nielsen traded patches to allow the SQL
standard IGNORE/RESPECT NULLS in lead and lag window functions.

Heikki Linnakangas sent in two more revisions of a patch to scale

Amit Kapila sent in another revision of a patch to allow changing GUCs
persistently from SQL.

Fabien COELHO sent in another revision of a patch to add long options
to pgbench.

Andres Freund sent in a patch to create a new contrib module: xidfuncs.

Jeff Janes sent in another revision of a patch to add a startup option
to pgbench.

Josh Kupershmidt sent in a patch to rename the specs directory to
something that won't interfer with certain OSs.

Andres Freund sent in another revision of a patch to create
infrastructure for and implement examples of pluggable compressors.

Gurjeet Singh sent in a patch to implement a function
pg_test_reload_conf() which allows you to know whether the changes
you've made to configuration parameters have actually taken effect
after a SIGHUP.

KONDO Mitsumasa sent in another revision of a patch to add --progress
to pgbench.

Andres Freund sent in two more revisions of the set of patches to
implement WAL decoding.

David Fetter sent in another revision of a patch to implement FILTER,
this time without the restriction that certain types of subqueries
couldn't be in the FILTER clause.  Dean Rasheed sent in a patch on top
of same to make FILTER an unreserved word.

Alexander Korotkov sent in a patch to fix an irregularity in trigram

Andres Freund sent in a WIP patch to fix a corner case in CASE.

Andrew Dunstan sent in a patch to fix pg_dump for foreign tables in
the pg_upgrade scenario.

Fabien COELHO sent in another revision of a patch to implement CREATE

Simon Riggs and Heikki Linnakangas traded patches to fix how hashes
work in some edge cases.

Fabien COELHO sent in another revision of a patch to implement pgbench

Noah Misch sent in another revision of a patch to make Windows behave
better with different encodings.

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