Logical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate

Scaling Postgres

Logical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate | Scaling Postgres 258

Mar 27 2023 | 00:08:41

00:00 / 00:08:41

Hosted By

Show Notes

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 and truncate.

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

https://www.scalingpostgres.com/episodes/258-logical-replication-database-antipatterns-max_wal_size-delete-vs-truncate/

Other Episodes

Episode 108

April 06, 2020 • 00:20:43

Ten Things, Audit Triggers, Schema Design, High Availability | Scaling Postgres 108

In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of...

Episode 169

June 14, 2021 • 00:18:46

Use Bigint, High Availability, Autocommit, Synchronized Sequential Scans | Scaling Postgres 169

In this episode of Scaling Postgres, we discuss only using bigint, high availability, Postgres autocommit and synchronized sequential scans. To get the show notes...

Episode 230

August 28, 2022 • 00:12:33

Stats Collector Gone, Handling Latency, PG In The Browser, Future High Availability | Scaling Postgres 230

In this episode of Scaling Postgres, we discuss how the stats collector disappears in PG15, steps to mitigate high latency connections, how to run...