When Postgres Can't, You Can!
summary
Provides concrete hacks and extensions that actually run in production at millions of users and terabytes of data: PG extractor uses pg_dump + pg_restore (and Perl) to filter schema objects and preserve privileges and comments; PG job monitor uses dblink to create pseudo‑autonomous logging with retry and Nagios‑style alerts; MIMO implements snapshot, incremental and trigger‑based logical replication from Oracle/Postgres; PG Partman automates time/serial partitions, precreates children and ships Python utilities to repartition large existing tables.
AI-written summary · about
chapters (12)
- 0:00Start
- 2:29PG Extractor
- 8:38When PostgreSQL Can't. You Can
- 9:51Extensions
- 13:41PG Job Monitor
- 25:02Types of Replication
- 33:00Use Cases
- 36:52PG Partition Manager
- 37:40Automated Creation
- 43:54Static Partitioning
- 44:59Dynamic Partitioning
- 45:34Automated Destruction
related talks
51mHow Postgres is misused and abused in the wild
01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & Extensibility
25mPG Extractor - A smarter pg dump
37mPostgres at Any Scale
13mBuilding reliable infrastructure with Postgres
32mAnonymizing Data in Postgres Without Losing Your Mind (or Your
38mWhat we built with Open Source
49mBeyond PostgreSQL 17