== PostgreSQL Weekly News - July 01 2007 ==

== PostgreSQL Weekly News - July 01 2007 ==

PgDay.it starts this week.  Speakers include Josh Berkus, Federico
Campoli, Paolo Cavallini, David Fetter and Enrico Pirozzi.

== PostgreSQL Product News ==

The ht://miner site now has an English version.
http://www.htminer.it/en/

PostgreSQL Maestro 7.6 released.
http://www.sqlmaestro.com/products/postgresql/maestro/

SE-PostgreSQL 1.0 Beta released.
http://code.google.com/p/sepgsql/

Slony-I 1.2.10 released.
http://slony.info/

== PostgreSQL Local ==

PDXPUG Day at OSCON is now soliciting for speakers.  Thanks to the
generosity of O'Reilly, we will have a full day of PostgreSQL sessions
the day before OSCON (Sunday, July 22nd).  Change your plane tickets
now and submit at talk!
http://developer.postgresql.org/index.php/OSCON07PGDay

Pgday.it in Prato, Tuscany, Italy on July 6 and 7.  That's this week!.

Some Important URLs:

Schedule: http://www.pgday.it/it/generale/programma
Registration: http://www.pgday.it/en/generale/registrazione
PGDay's web site: http://www.pgday.it/en/
Sponsorship campaign: http://www.pgday.it/en/sponsorizzazioni/come
How to get to Prato: http://www.pgday.it/en/logistica/raggiungere_prato
Accommodations in Prato: http://www.pgday.it/en/logistica/dove_dormire
PostgreSQL official T-shirts http://www.prato.linux.it/node/30
Key-signing Party: http://www.pgday.it/en/keysigning

== PostgreSQL in the News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News is brought to you this week by David Fetter

To get your submission into the upcoming issue, make sure it arrives
at david@fetter.org or in German at pwn@pgug.de by Sunday at 3:00pm
Pacific Time.

== Applied Patches ==

Bruce Momjian committed:

- Mark TODO as done: "Reduce checkpoint performance degredation by
  forcing data to disk."

Neil Conway committed:

- A patch which makes \df+ tell whether a function is IMMUTABLE,
  STABLE or VOLATILE.

Tom Lane committed:

- Reduce the maximum sleep interval in the autovac launcher to 1
  second, so that it responds to SIGQUIT reasonably promptly even on
  machines where SA_RESTART signals restart a sleep from scratch.
  (This whole area could stand some rethinking, but for now make it
  work like the other processes do.)  Also some marginal stylistic
  cleanups.

- Treat the autovac launcher more like a regular backend, in that we
  wait for it to die before telling the bgwriter to initiate shutdown
  checkpoint.  Since it's connected to shared memory, this seems more
  prudent than the alternative of letting it quit asynchronously.
  Resolves my complaint of yesterday about repeated shutdown
  checkpoints in CVS HEAD.

- Avoid memory leakage when a series of subtransactions invoke AFTER
  triggers that are fired at end-of-statement (as is the normal case
  for foreign keys, for example).  In this situation the per-subxact
  deferred trigger context is always empty when subtransaction exit is
  reached; so we could free it, but were not doing so, leading to an
  intratransaction leak of 8K or more per subtransaction.  Per
  off-list example from Viatcheslav Kalinin subsequent to bug #3418
  (his original bug report omitted a foreign key constraint needed to
  cause this leak).  Back-patch to 8.2; prior versions were not using
  per-subxact contexts for deferred triggers, so did not have this
  leak.

- In pgsql/src/backend/storage/ipc/procarray.c, fix comments not
  updated in recent patch.

- In pgsql/src/backend/postmaster/autovacuum.c, add 'volatile' to
  suppress 'variable might be clobbered by longjmp' warning emitted by
  some versions of gcc.

- Improve logging of checkpoints.  Patch by Greg Smith, worked over by
  Heikki Linnakangas and a little bit by me.

- Fix computation of PG_VERSION_NUM by configure: remove unnecessary
  and unportable backslashes in awk script (per Patrick Welche), and
  add brackets to prevent autoconf from mangling sed's regexp (the sed
  call here never did what was expected).

- In pgsql/doc/src/sgml/backup.sgml, add a note that pg_start_backup
  will take awhile because of new distributed checkpoint behavior.
  Explain how to work around this by issuing a manual CHECKPOINT
  command.  Per discussion with Heikki Linnakangas.

- Fix a passel of ancient bugs in to_char(), including two distinct
  buffer overruns (neither of which seem likely to be exploitable as
  security holes, fortunately, since the provoker can't control the
  data written).  One of these is due to choosing to stomp on the
  output of a called function, which is bad news in any case; make it
  treat the called functions' results as read-only.  Avoid some
  unnecessary palloc/pfree traffic too; it's not really helpful to
  free small temporary objects, and again this is presuming more than
  it ought to about the nature of the results of called functions.
  Per report from Patrick Welche and additional code-reading by Imad.

- Fix incorrect tests for undef Perl values in some places in
  plperl.c.  The correct test for defined-ness is SvOK(sv), not
  anything involving SvTYPE.  Per bug #3415 from Matt Taylor.
  Back-patch as far as 8.0; no apparent problem in 7.x.

- Implement "distributed" checkpoints in which the checkpoint I/O is
  spread over a fairly long period of time, rather than being spat out
  in a burst.  This happens only for background checkpoints carried
  out by the bgwriter; other cases, such as a shutdown checkpoint, are
  still done at full speed.  Remove the "all buffers" scan in the
  bgwriter, and associated stats infrastructure, since this seems no
  longer very useful when the checkpoint itself is properly throttled.
  Original patch by Itagaki Takahiro, reworked by Heikki Linnakangas,
  and some minor API editorialization by me.

- Fix PGXS conventions so that extensions can be built against
  Postgres installations whose pg_config program does not appear first
  in the PATH.  Per gripe from Eddie Stanley and subsequent
  discussions with Fabien Coelho and others.

Magnus Hagander committed:

- Add notes about configuring Visual Studio Express for use with the
  Platform SDK.

- Andrew Dunstan's patch which adds extra checks for buildfarm to pick
  up errors when running on XP or earlier versions of Windows.

Alvaro Herrera committed:

- Avoid crash in interrupted autovacuum worker, caused by leaving the
  current memory context pointing at a context not long lived enough.
  Also, create a fake PortalContext where to store the vac_context, if
  only to avoid having it be a top-level memory context.

- Arrange for SIGINT in autovacuum workers to cancel the current table
  and continue with the schedule.  Change current uses of SIGINT to
  abort a worker into SIGTERM, which keeps the old behaviour of
  terminating the process.  Patch from ITAGAKI Takahiro, with some
  editorializing of my own.

- Remove unused "caller" argument from stringToQualifiedNameList.

- Remove unused BAD_LOCATION definition.

- Improve autovacuum launcher's ability to detect a problem in worker
  startup, by having the postmaster signal it when certain failures
  occur.  This requires the postmaster setting a flag in shared
  memory, but should be as safe as the pmsignal.c code is.  Also make
  sure the launcher honor's a postgresql.conf change turning it off on
  SIGHUP.

== Rejected Patches (for now) ==

Alvaro Herrera's patch to remove SIBackendInit's return value.

== Pending Patches ==

Zdenek Kotala sent in a patch reflecting New Zealand's new DST rules.

Gregory Stark sent in a patch to create reserved words for OLAP
windowing functions.

ITAGAKI Takahiro sent in a bug fix for pgstat_drop_relation.

Pavan Deolasee sent in another version of his HOT patch.

Dave Page sent in a patch which fixes some bugs in pg_ctl on Windows.

Jacob Rief sent in a patch to make SPI-header-files safe for C++
compilers.

Patrick Welche sent in a patch intended to address some issues with
using XML on OpenBSD.

Andrew Dunstan sent in two revisions of a patch intended to allow
logging to CSV files.

Heikki Linnakangas sent in a document update for pg_start_backup,
notifying people that it may now take longer to finish.

Kevin Grittner sent in two revisions of a document patch intended to
clarify how warm standby works.

Robert Treat sent in a patch to improve dblink's connection security.

David Fetter sent in a two revisions of a patch which implements ALTER
[VIEW | SEQUENCE] RENAME TO.