On Thursday, 20th of November, Peter Eisentraut committed his own patch, which adds new command to PostgreSQL: TABLE. While this command doesn't do anything that wasn't available earlier, it's worth mentioning, as it's one of patches that make PostgreSQL compatible with ...
On 19th of November Tom Lane committed patch by Takahiro Itagaki which does: Add auto-explain contrib module for automatic logging of the plans of slow-running queries.
Finally, we got very important addons to PostgreSQL, which help with dealing with arrays. It solves a lot of problems, which were usually solved with standard cookbook code, which was in faqs, blog posts and number of examples on irc.
On 3rd of November Andrew Dunstan committed his patch which adds new function to PostgreSQL - suppress_redundant_updates_trigger(). This function is not for using in selects, but it can help you tremendously if your database access matches certain pattern.
In PostgreSQL 8.2, we got "RETURNING" clause in INSERT/UPDATE/DELETE queries. Unfortunately it could not be used as source of rows for anything in sql. insert into table_backup delete from table where ... returning *; Well, it's still not possible, but it is a ...
On 28th of October Tom Lane committed his patch that changes some internals of functions, but it also adds interesting capability.
On 4th of September Tom Lane committed another great patch. This one is very large, and even after applying - it's has some rough edges. There will be need for additional patches to make the functionality fully robust, but the ...
On 30th of September, Heikki Linnakangas committed his patch that changes FSM: Rewrite the FSM. Instead of relying on a fixed-size shared memory segment, the free space information is stored in a dedicated FSM relation fork, with each relation (except for hash indexes; ...
On 23rd of September, Heikki Linnakangas committed patch that was written by Radek Strnad (actually committed patch is a stripped-down version of original). What it does? It adds ability to have (finally!) different collation order and character categories for different databases.
Takahiro Itagaki wrote, and Tom Lane committed nice patch, which I personally find really helpful: Add a duration option to pgbench, so that test length can be specified in seconds instead of by number of transactions to run. Takahiro Itagaki
