Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259

Episode 259 April 02, 2023 00:13:34
Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259
Scaling Postgres
Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259

Apr 02 2023 | 00:13:34

/

Hosted By

Creston Jamison

Show Notes

 

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 and highlights coming in Postgres 16.

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 342

November 17, 2024 00:13:19
Episode Cover

Faster Writes With ZFS? | Scaling Postgres 342

In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database,...

Listen

Episode 242

November 21, 2022 00:11:38
Episode Cover

Reduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers | Scaling Postgres 242

In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS...

Listen

Episode 195

December 13, 2021 00:18:31
Episode Cover

Aurora vs. Postgres, Surprising Transactions, Write-Only & Read-Only, Indexing Advice | Scaling Postgres 195

In this episode of Scaling Postgres, we discuss Aurora vs. Postgres, surprising transaction behavior, write-only & read-only database connections and indexing best practices. To...

Listen