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 75

August 05, 2019 • 00:15:40

Combining Indexes, Regular Expressions, Parallelism, PostGIS | Scaling Postgres 75

In this episode of Scaling Postgres, we discuss combining indexes, regular expressions, parallelism in Postgres and PostGIS content. To get the show notes as...

Episode 22

July 23, 2018 • 00:11:43

Concurrency, Listen & Notify, ZFS, pg_rewind | Scaling Postgres 22

In this episode of Scaling Postgres, we review articles covering concurrency, how to use listen & notify, zfs, caution regarding pg_rewind. To get the...

Episode 158

March 28, 2021 • 00:19:48

Vacuum Speed Up, Faster Foreign Tables, Fast Queries With Union, Query Optimizer | Scaling Postgres 158

In this episode of Scaling Postgres, we discuss a vacuum speed up and faster foreign tables in Postgres 14, running faster queries with union...