April 10th, 2009 by depesz | Tags: , , , | No comments »

For quite some time I've been posting about new features in 8.4. First post was over a year ago, on 16th of February 2008. Now, we just (yesterday) got nice surprise: beta is here: (depesz@[local]:5840) 12:39:15 [depesz] # select version(); ...

Usually I write about new features in 8.4, but this time I'd like to write about feature that will be actually missing in 8.4. And thank God, it will be missing. On Mon, 09 Mar 2009 11:22:47 -0400 Greg Sabino Mullane ...

On 2nd of February Andrew Dunstan committed his patch (with editing by Tom Lane) that: Log Message: ----------- Provide for parallel restoration from a custom format archive. Each data and post-data step is run in a separate worker child (a thread on Windows, a ...

On 22nd of January, Tom Lane committed patch by Stephen Frost, which adds column level privileges: Log Message: ----------- Support column-level privileges, as required by SQL standard. Stephen Frost, with help from KaiGai Kohei and others

A long overdue post about new functionality. At this moment it is no longer such new, as it was committed on 28th of December (yes, I know, I should have written it earlier, Sorry). On this day Tom Lane committed patch ...

On 4th of January, Tom Lane committed patch by Takahiro Itagaki, which adds new contrib module - pg_stat_statements: Log Message: ----------- Add contrib/pg_stat_statements for server-wide tracking of statement execution statistics. Takahiro Itagaki

On 6th of January Bruce Momjian committed patch by Greg Sabino Mulane, which fixes one of a very long standing annoyances in PostgreSQL - removes system objects from \dX commands in psql.

Yesterday Tom Lane committed enormous patch, which had commit log: Support window functions a la SQL:2008. Hitoshi Harada, with some kibitzing from Heikki and Tom. ... and that would be all. I will write more about it, its use cases, and some ...

On 4th of December Peter Eisentraut committed patch by Pavel Stehule (with Peters tweaks) which adds default values for function arguments: Default values for function arguments Pavel Stehule, with some tweaks by Peter Eisentraut

Yeah. This one patch alone is worth upgrading to 8.4. On 3rd of December Heikki Linnakangas committed his patch. Commit message: Introduce visibility map. The visibility map is a bitmap with one bit per heap page, where a set bit indicates that all ...