PostgreSQL 9.1 Grand Tour
- Synchronous replication
- Replication tools
- Per-Column collation
- Serialized Snapshot Isolation
- Unlogged tables
- K-Nearest Neighbor
- Other Features
Land of Surreal Queries: Writable CTEs
-- This is in 8.4 WITH deleted_posts AS ( DELETE FROM posts WHERE created < now() - '6 months'::INTERVAL RETURNING * ) SELECT user_id, count(*) FROM deleted_posts GROUP BY 1
In 9.1, you can do UPDATE on that.
Sometimes you have data where if something happens, you don't care. Unlogged tables are much faster, but you risk data loss.
CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA ext;
Handling for FDW, which is Foreign Data Wrappers.
- Valid-on-creation FKs
- Extensible ENUMs
- Triggers on Views
- Reduced NUMERIC size
- ALTER TYPE without rewrite
pg_dumpdirectory format as a precursor for parralel