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 144

December 13, 2020 00:12:09
Episode Cover

Postgres Migration, Bulk Data Loading, Updates vs. Upgrades, UUID Benchmarks | Scaling Postgres 144

In this episode of Scaling Postgres, we discuss a Mongo to Postgres migration, the best way to bulk load data, running an update vs....

Listen

Episode 237

October 16, 2022 00:18:53
Episode Cover

Postgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 237

In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection...

Listen

Episode 183

September 20, 2021 00:14:50
Episode Cover

Broken Indexes, Trademark Issues, Percentile vs. Average, Logical Improvements | Scaling Postgres 183

In this episode of Scaling Postgres, we discuss one cause of broken indexes, Postgres trademark issues, percentiles vs. averages and logical replication improvements. To...

Listen