On 8th of December, Simon Riggs committed patch: REINDEX SCHEMA Add new SCHEMA option to REINDEX and reindexdb. Sawada Masahiko Reviewed by Michael Paquier and Fabrízio de Royes Mello

Recent release of new versions of PostgreSQL suggests that you do reindex of all indexes. But this will take a while, and since we don't actually have 'REINDEX CONCURRENTLY' command - it's a bit tricky. So, since I will be doing ...

Three patches for you today, all committed by Robert Hass: On 7th of February, patch: Add a transform function for numeric typmod coercisions. This enables ALTER TABLE to skip table and index rebuilds when a column is changed to an unconstrained numeric, or when ...

On 18th of July, Robert Haas committed patch: Avoid index rebuild for no-rewrite ALTER TABLE .. ALTER TYPE. Noah Misch. Review and minor cosmetic changes by me.

On 25th of January, Tom Lane committed patch: Implement ALTER TABLE ADD UNIQUE/PRIMARY KEY USING INDEX.   This feature allows a unique or pkey constraint to be created using an already-existing unique index. While the constraint isn't very functionally different from the bare index, ...

Some time ago Joshua Tolley described how to reduce bloat from tables without locking (well, some locks are there, but very short, and not really intrusive). Side note: Joshua: big thanks, great idea. Based on his idea and some our research, i ...

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