Waiting for 9.0 – Streaming replication

The BIG feature. The feature that made PostgreSQL leap from 8.4 to 9.0. Patch was written by Fujii Masao, and committed by Heikki Linnakangas on 15th of January 2010: Log Message: ———– Introduce Streaming Replication.   This includes two new kinds of postmaster processes, walsenders and walreceiver. Walreceiver is responsible for connecting to the primary … Continue reading “Waiting for 9.0 – Streaming replication”

Waiting for 8.5 – VACUUM FULL change

Some time ago Josh Berkus wrote about possible changes in VACUUM FULL. Now these changes came to life. By now, I mean 6th of January, when Takahiro Itagaki committed his patch: Log Message: ———– Support rewritten-based full vacuum as VACUUM FULL. Traditional VACUUM FULL was renamed to VACUUM FULL INPLACE. Also added a new option … Continue reading “Waiting for 8.5 – VACUUM FULL change”

Waiting for 8.5 – ordered aggregates

On 15th of December Tom Lane committed patch by Andrew Gierth (aka RhodiumToad), which adds interesting capability: Log Message: ———– Support ORDER BY within aggregate function calls, at long last providing a non-kluge method for controlling the order in which values are fed to an aggregate function. At the same time eliminate the old implementation … Continue reading “Waiting for 8.5 – ordered aggregates”

Waiting for 8.5 – exclusion constraints

On 7th of December, Tom Lane committed patch by Jeff Davis that adds general exclusion constraints: Log Message: ———– Add exclusion constraints, which generalize the concept of uniqueness to support any indexable commutative operator, not just equality. Two rows violate the exclusion constraint if "row1.col OP row2.col" is TRUE for each of the columns in … Continue reading “Waiting for 8.5 – exclusion constraints”

Waiting for 8.5 – Application name reporting

On 28th of November Tom Lane committed patch by Dave Page, which adds new capability to system monitoring and logging: Log Message: ———– Add support for an application_name parameter, which is displayed in pg_stat_activity and recorded in log entries.   Dave Page, reviewed by Andres Freund

Waiting for 8.5 – better wrapped output in psql

On 22nd of November Tom Lane committed patch by Roger Leigh which fixes my pet peeve: Log Message: ———– Improve psql’s tabular display of wrapped-around data by inserting markers in the formerly-always-blank columns just to left and right of the data. Different marking is used for a line break caused by a newline in the … Continue reading “Waiting for 8.5 – better wrapped output in psql”

Waiting for 8.5 – conditional triggers

On 20th of November Tom Lane committed patch by Takahiro Itagaki which adds interesting functionality: ADD a WHEN clause TO CREATE TRIGGER, allowing a BOOLEAN expression TO be checked TO determine whether the TRIGGER should be fired.   FOR BEFORE triggers this IS mostly a matter OF spec compliance; but FOR AFTER triggers it can … Continue reading “Waiting for 8.5 – conditional triggers”

Waiting for 8.5 – TRIGGERS on columns

On 14th of October Tome Lane committed new patch from Itagaki Tahahiro: Log Message: ———– Support SQL-compliant triggers ON COLUMNS, ie fire ONLY IF certain COLUMNS are named IN the UPDATE’s SET list.   Note: the schema of pg_trigger has not actually changed; we’ve just started TO USE a COLUMN that was there ALL along. … Continue reading “Waiting for 8.5 – TRIGGERS on columns”