Skip site navigation (1) Skip section navigation (2)

== PostgreSQL Weekly News - December 14 2008 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - December 14 2008 ==
Date: 2008-12-15 07:28:19
Message-ID: 20081215072819.GF17360@fetter.org (view raw or flat)
Thread:
Lists: pgsql-announce
== PostgreSQL Weekly News - December 14 2008 ==

Welcome to PostgreSQL's newest member, Pascal Scherbaum. :)
http://pascal.scherbaum.la/index.en.php

Mark Wong and others have started a monthly meeting on PostgreSQL
performance.  The first meeting will be January 8, 7:00pm at Portland
State University, Fourth Ave Building, Room 86-01.  RSVP to the PDXPUG
list.

ARPUG has put up a Pootle server for translation.
http://pootle.arpug.com.ar/

== PostgreSQL Product News ==

Archiveopteryx 3.0.5 released.
http://www.archiveopteryx.org/3.0.4

Turnkey Linux has released a PostgreSQL appliance.
http://www.turnkeylinux.org/appliances/postgresql

== PostgreSQL Jobs for December ==

http://archives.postgresql.org/pgsql-jobs/2008-12/threads.php

== PostgreSQL Local ==

The Call for Papers for FOSDEM 2009 has begun.  PostgreSQL will have a
booth and will share a developer room with the BSD groups.  Please
submit your talks to fosdem (at) postgresql (dot) eu.  The deadline is
2009-01-02.

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.

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

== Applied Patches ==

Magnus Hagander committed:

- In pgsql/doc/src/sgml/config.sgml, add note that autovacuum can use
  up several times maintenance_work_mem, with warning against setting
  it too high.

- In pgsql/doc/src/sgml/maintenance.sgml, clarify how processes are
  started by autovacuum, and what the effect of autovacuum_max_workers
  parameter is.  Per discussion with Alvaro Herrera.

- In pgsql/src/backend/libpq/be-secure.c, replace both send and
  receive BIO routines in the SSL code with our own, calling recv()
  and send(). This makes the calls go through the socket emulation
  code on Win32, making them for example properly interruptible.

Tom Lane committed:

- In pgsql/src/backend/postmaster/pgstat.c, teach pgstat_vacuum_stat
  to not bother scanning pg_proc in the common case where no function
  stats entries exist.  Partial response to Pavel Stehule's
  observation that small VACUUM operations are noticeably slower in
  CVS HEAD than 8.3.

- In pgsql/doc/src/sgml/syntax.sgml, add a specific example of
  parenthesizing when extracting a field of a composite column.  Might
  help cut down on future questions...

- In pgsql/src/backend/storage/freespace/fsmpage.c, tweak the tree
  descent loop in fsm_search_avail to not look at the right child if
  it doesn't need to.  This saves some miniscule number of cycles, but
  the ulterior motive is to avoid an optimization bug known to exist
  in SCO's C compiler (and perhaps others?)

- To reduce confusion over whether VACUUM FULL is needed for
  anti-wraparound vacuuming (it's not), say "database-wide VACUUM"
  instead of "full-database VACUUM" in the relevant hint messages.
  Also, document the permissions needed to do this.  Per today's
  discussion.

- Fix failure to ensure that a snapshot is available to datatype input
  functions when they are invoked by the parser.  We had been setting
  up a snapshot at plan time but really it needs to be done earlier,
  before parse analysis.  Per report from Dmitry Koterov.  Also fix
  two related problems discovered while poking at this one:
  exec_bind_message called datatype input functions without
  establishing a snapshot, and SET CONSTRAINTS IMMEDIATE could call
  trigger functions without establishing a snapshot.  Backpatch to
  8.2.  The underlying problem goes much further back, but it is
  masked in 8.1 and before because we didn't attempt to invoke domain
  check constraints within datatype input.  It would only be exposed
  if a C-language datatype input function used the snapshot; which
  evidently none do, or we'd have heard complaints sooner.  Since this
  code has changed a lot over time, a back-patch is hardly risk-free,
  and so I'm disinclined to patch further than absolutely necessary.

- Remove pg_plan_queries()'s now-useless needSnapshot parameter.  It's
  useless in 8.3, too, but I'm not back-patching this change since it
  would break any extension modules that might be calling that
  function.

- Increase the default value of default_statistics_target from 10 to
  100, and its maximum value from 1000 to 10000.  ALTER TABLE SET
  STATISTICS similarly now allows a value up to 10000.  Per
  discussion.

- Restore enforce_generic_type_consistency's pre-8.3 behavior of
  allowing an actual argument type of ANYARRAY to match an argument
  declared ANYARRAY, so long as ANYELEMENT etc aren't used.  I had
  overlooked the fact that this is a possible case while fixing bug
  #3852; but it is possible because pg_statistic contains columns
  declared ANYARRAY.  Per gripe from Corey Horton.

Heikki Linnakangas committed:

- Provide support for multiplexing SIGUSR1 signal.  The upcoming
  synchronous replication patch needs a signal, but we've already used
  SIGUSR1 and SIGUSR2 in normal backends.  This patch allows reusing
  SIGUSR1 for that, and for other purposes too if the need arises.

- Revert SIGUSR1 multiplexing patch, per Tom's objection.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/wal.sgml, update journaling performance docs
  based on comments by Michael Renner.

Peter Eisentraut committed:

- Append major version number and for libraries soname major version
  number to the gettext domain name, to simplify parallel installations.
  Also, rename set_text_domain() to pg_bindtextdomain(), because that
  is what it does.

- Move carefully obscured SunOS 4 specific #include out of c.h into
  port header file.  SunOS 4 is probably broken anyway, but this item
  stuck out as completely weird.

- The macros NULL_DEV and DEVNULL were both used to work around
  platform-specific spellings of /dev/null.  But one should be enough,
  so settle on DEVNULL.

Michael Meskes committed:

- In pgsql/src/interfaces/ecpg/preproc/ecpg.trailer, using clause has
  to accept signed numeric constants too.

Alvaro Herrera committed:

- Reduce some rel.h inclusions, and add pg_list.h to pg_proc_fn.h.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Peter Eisentraut and Martin Pihlak sent in revised versions a patch to
add an SQL/MED-compatible connection manager.

Heikki Linnakangas and Fujii Masao sent in revised versions of a patch
to multiplex SIGUSR1 for synchronous replication.

Magnus Hagander sent in another revision of the patch to add an
sslcert option to libpq connections.

Magnus Hagander sent in a patch which replaces the current SSL BIO
wrapper code.

Gregory Stark sent in two more revisions of the posix fadvise patch.

Andrew Dunstan sent in another revision of his patch to do parallel
restore.

Emmanuel Cecchet sent in another revision of his patch to do automated
partitioning.

Emmanuel Cecchet sent in another revision of his patch to do help with
transactions on temporary tables.

Teodor Sigaev sent in another revision of his GIN improvements patch.


pgsql-announce by date

Next:From: Devrim GÜNDÜZDate: 2008-12-15 08:54:46
Subject: Releasing new version of PostgreSQL Live CD
Previous:From: Francisco Figueiredo Jr.Date: 2008-12-15 04:34:30
Subject: Npgsql 2.0.2 released!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group