== PostgreSQL Weekly News - December 28 2008 ==

== PostgreSQL Weekly News - December 28 2008 ==

Hitoshi Harada et al. have added OLAP functions to PostgreSQL. Kudos!

Stefan Kaltenbrunner and Susanne Ebrecht will be presenting at the
25th Chaos Communication Congress in Berlin, December 27-30, 2008.
http://events.ccc.de/congress/2008/

== PostgreSQL Product News ==

GNUmed 0.3.8 released.
http://wiki.gnumed.de/bin/view/Gnumed

== PostgreSQL Jobs for December ==

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

== PostgreSQL Local ==

The ArPug's first meeting will be on December 30, 2008, 19:00 at
Globant Costa Salguero Office and on <irc://irc.freenode.net/arpug>.
http://www.arpug.com.ar/trac/wiki/Reunion1

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.

SYDPUG will be meeting February 3, 2009 at 6:30pm. Watch this space
for details.
http://archives.postgresql.org/sydpug/

Andreas 'ads' Scherbaum will be presenting a talk at Perl Workshop
2009 on February 25 in Frankfurt am Main, Germany.
http://www.perl-workshop.de/talks/151/view

PGCon 2009 will be held 21-22 May 2009, in Ottawa at the University of
Ottawa. It will be preceded by two days of tutorials on 19-20 May
2009.
http://www.pgcon.org/2009/papers.php

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

Bruce Momjian committed:

- Change the name of dtrace wal tracepoints to
TRACE_POSTGRESQL_WAL_BUFFER_WRITE_DIRTY. Robert Lor.

Tom Lane committed:

- Remove unused include file pgsql/src/include/storage itempos.h, per
ITAGAKI Takahiro. AFAICT this has been dead code since Postgres95.

- Make a couple of small changes to the tuplestore API, for the
benefit of the upcoming window-functions patch. First,
tuplestore_trim is now an exported function that must be explicitly
invoked by callers at appropriate times, rather than something that
tuplestore tries to do behind the scenes. Second, a read pointer
that is marked as allowing backward scan no longer prevents
truncation. This means that a read pointer marked as having
BACKWARD but not REWIND capability can only safely read backwards as
far as the oldest other read pointer. (The expected use pattern for
this involves having another read pointer that serves as the
truncation fencepost.)

- Support window functions a la SQL:2008. Hitoshi Harada, with some
kibitzing from Heikki and Tom.

- Tighten up a couple of regression test cases that can have
platform-dependent results due to underspecified ordering. Per
report from buildfarm member pika.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Alvaro Herrera sent in another revision of his patch to improve
reloption handling.

Robert Lor sent in a patch atop his DTrace probes patch to change some
names.

Bernd Helmle sent in another revision of his writable views patch.

Heikki Linnakangas sent in a patch to fix some issues around the new
visibility map and VACUUM.

Kenneth Marshall sent in another revision of his internal hash
function patch.

Heikki Linnakangas sent in another revision of his infrastructure
patch for recovery.

Fujii Masao sent in three revisions of a patch to skip checkpoint at
pg_start_backup.

KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.

Fujii Masao sent in a patch to support archive control for synchronous
replication.

ITAGAKI Takahiro sent in another revision of his pg_stat_statements
patch.

Hiroshi Inoue sent in a patch intended to fix bug 4186 (set
lc_messages does not work).

Koichi Suzuki sent in another revision of his patch to improve PITR
performance.

Erik Rijkers sent in a patch which clarifies the --help message for
the -c option in pg_restore.