On 16th of July, Kevin Grittner committed patch: Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY. This allows reads to continue without any blocking while a REFRESH runs. The new data appears atomically as part of transaction commit. Review questioned the Assert that a matview ...

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

On 6th of April, Simon Riggs committed patch: Add DROP INDEX CONCURRENTLY [IF EXISTS], uses ShareUpdateExclusiveLock

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