Latest Episodes
260
PL/Rust, Row Locks, Postgres Errors, SQL 2023 | Scaling Postgres 260
In this episode of Scaling Postgres, we discuss PL/Rust 1.0 release, row locks, Postgres errors and the new SQL 2023 standard. To get the...
259
Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259
In this episode of Scaling Postgres, we discuss max_wal_size as it relates to recovery time, losing your data with collation changes, getting production ready...
258
Logical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate | Scaling Postgres 258
In this episode of Scaling Postgres, we discuss use cases for logical replication, database anti-patterns, how to set max_wal_size and the difference between delete...
257
Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257
In this episode of Scaling Postgres, we discuss Instacart adopting PgCat, binning or bucketing your data by time, the best settings for work_mem and...
256
11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256
In this episode of Scaling Postgres, we discuss WAL growing to 11 Terabytes, pgec supporting writes, Patroni 3.0 & Citus for high availability, and...
255
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255
In this episode of Scaling Postgres, we discuss how to detect & handle integer overflows, a wish for user-friendly permissions, using a dump to...