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 92

December 02, 2019 00:13:17
Episode Cover

Book Sales, B-tree Boost, More Postgres 12, Using pgBackRest | Scaling Postgres 92

In this episode of Scaling Postgres, we discuss book sales, boosts to b-tree indexes, more Postgres 12 features and how to setup and use...

Listen

Episode 12

May 14, 2018 00:11:12
Episode Cover

The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 12

In this episode of Scaling Postgres, we review articles covering the future of databases, why counting is slow, the best ways to avoid ORs,...

Listen

Episode 127

August 17, 2020 00:14:37
Episode Cover

Recursive Queries, Lateral Joins, Pagination, JSONB Arrays | Scaling Postgres 127

In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays....

Listen