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/ 

Previous Episode
Next Episode

Other Episodes

Episode 249

January 23, 2023 • 00:09:06
Episode Cover

Locking Tables, Foreign Key Issue, Slow Decimals, Memoize & Joins | Scaling Postgres 249

In this episode of Scaling Postgres, we discuss issues with locking tables, foreign keys and slow decimals. We also cover when joins use memoize....

Listen

Episode 205

March 07, 2022 • 00:09:56
Episode Cover

Indexing With tsearch, Tuples Not Yet Removable, Wicked Problems, Pattern Matching | Scaling Postgres 205

In this episode of Scaling Postgres, we discuss the best ways to index with tsearch, what to check if tuples are not yet removable,...

Listen

Episode 261

April 17, 2023 • 00:16:24
Episode Cover

Easy Foreign Data Wrappers, JSONB Cheatsheet, Updating Cost Limit, Parallel Aggregate | Scaling Postgres 261

  In this episode of Scaling Postgres, we discuss how to easily crate a foreign data wrapper to consume an API, present a convenient JSONB...

Listen