11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256

Episode 256 March 12, 2023 00:12:23
11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256
Scaling Postgres
11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256

Mar 12 2023 | 00:12:23

/

Hosted By

Creston Jamison

Show Notes

In this episode of Scaling Postgres, we discuss WAL growing to 11 Terabytes, pgec supporting writes, Patroni 3.0 & Citus for high availability, and setting up PostgREST.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/255-integer-overflow-user-friendly-permissions-dump-logical-replication-worker-config/ 

Other Episodes

Episode 203

February 20, 2022 00:12:11
Episode Cover

Saving Space, Working with TOAST, Protecting Data, High CPU Utilization | Scaling Postgres 203

In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go...

Listen

Episode 170

June 20, 2021 00:15:08
Episode Cover

Redis vs Postgres, Hard Quadrant, Optimizing Joins, Materialized Views | Scaling Postgres 170

In this episode of Scaling Postgres, we discuss Redis vs. Postgres, working in the hard quadrant, how Postgres optimizes joins and working with materialized...

Listen

Episode 291

November 19, 2023 00:18:15
Episode Cover

2 To 4 Times Faster With Vectorization | Scaling Postgres 291

In this episode of Scaling Postgres, we discuss Timescale's performance improvements from adding a query vectorization pipeline, doing blue-green deployments for databases, using reserved_connections...

Listen