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 168

June 06, 2021 • 00:16:06

Managing Autovacuum, Better JSON, Avoiding Updates, OS Tuning | Scaling Postgres 168

In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system tuning....

Episode 11

May 07, 2018 • 00:12:13

Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11

In this episode of Scaling Postgres, we review articles covering serializable, JSON & JSONB data types, fast data loading with Ruby and Postgres 11...

Episode 213

May 01, 2022 • 00:15:54

Planner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 213

In this episode of Scaling Postgres, we discuss ways you can optimize the planner, becoming part of the Postgres Community, considerations for large databases...