Postgres Architectures in Production
When using PostgreSQL in production it is important to implement a strategy for High Availability. With a database service, the HA properties apply to both the service itself and of course to the data set. In this talk we learn how to think about specific HA needs of your production environment and how to achieve your requirements with Open Source tooling when it comes to your database of choice, PostgreSQL. In particular, we dive in many options that could be implemented for Postgres to evolve its offering from being a toolset to being “batteries included”. What does it mean in the context of HA? How to achieve it?
▶︎
Large Table Partitioning with PostgreSQL and Django
▶︎
Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs | Citus Con 2023
▶︎
PostgreSQL Internals in Action: MVCC
▶︎
High Availability PostgreSQL with Patroni – Full Setup Tutorial
▶︎
Analytics for not-so-big data with DuckDB - David Ostrovsky - NDC Oslo 2025
▶︎
Tuning PostgreSQL for High Write Workloads
▶︎
How does PostgreSQL actually work
▶︎
Optimizing autovacuum: PostgreSQL’s vacuum cleaner | Citus Con: An Event for Postgres 2022
▶︎
PostgreSQL continuous backup and PITR with Barman
▶︎
PostgreSQL HA High Availability Tutorial
▶︎
The Challenges of Distributing Postgres: A Citus Story | Citus Data
▶︎
A Detailed Understanding of MVCC and Autovacuum Internals in PostgreSQL 14 - Avinash Vallarapu
▶︎
For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL | Citus Con 2023
▶︎
Webinar: Tuning Tips to Maximize Postgres Performance
▶︎
A talk about indexes
▶︎
Where We’re Going, We Don’t Need Rows: Columnar Data Connectivity with Apache Arrow ADBC (Ian Cook)
▶︎
Scale Through Sharding | Scaling Postgres 308
▶︎
Explaining the Postgres Query Optimizer | Citus Con: An Event for Postgres 2022
▶︎
The Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL - Jim Mlodgenski
▶︎