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 one step closer, thanks to patch written and committed by Tom Lane … Continue reading “Waiting for 8.4 – sql-wrappable RETURNING”
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; they don’t use FSM). This eliminates the max_fsm_relations and max_fsm_pages GUC … Continue reading “Waiting for 8.4 – new FSM (Free Space Map)”
Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate – just like GROUP BY.
Pavel Stehule wrote, and then Tom Lane committed (on 16th of July), patch which adds to PostgreSQL support for functions with variable number of arguments.
Gregory Stark wrote, and Bruce Momjian committed (on 14th of July) patch which shows storage type in psql.
Today we have two interesting patches: patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART” option to ALTER SEQUENCE. With some interesting consequences
Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:
Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).
Today we have one new feature – extension of plpgsql’s RAISE command.