pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. Replicate your data with this alternative to physical replication & achieve zero-downtime.
Postgres doesn’t reclaim space when dropping a column which can be a problem in situations where you create and remove many temporary columns.. An interesting story.
Building a robust background worker system that leverages transactional isolation to never work a job too early, and transactional durability to never let one drop.
