Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257

Episode 257 March 19, 2023 00:19:16
Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257
Scaling Postgres
Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257

Mar 19 2023 | 00:19:16

/

Hosted By

Creston Jamison

Show Notes

In this episode of Scaling Postgres, we discuss Instacart adopting PgCat, binning or bucketing your data by time, the best settings for work_mem and how to avoid bad check constraints.

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

https://www.scalingpostgres.com/episodes/257-adopting-pgcat-time-bins-work_mem-settings-bad-constraints/

Other Episodes

Episode 59

April 14, 2019 00:12:20
Episode Cover

Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59

In this episode of Scaling Postgres, we review articles covering Posgres' popularity, conducting load testing, checksums in PG12 and pg_hba configuration. To get the...

Listen

Episode 351

February 02, 2025 00:16:55
Episode Cover

Features To Avoid? | Scaling Postgres 351

In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a...

Listen

Episode 129

August 30, 2020 00:15:58
Episode Cover

28 Tips, Lucky 13, Autovacuum Tuning, Logical Pitfalls | Scaling Postgres 129

In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls. To get...

Listen