Latest Episodes
261
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...
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...