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 105

March 16, 2020 00:19:22
Episode Cover

World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105

In this episode of Scaling Postgres, we discuss how Postgres is the world's best database, performance ramifications of subtransactions, the current state of sharding...

Listen

Episode 227

August 07, 2022 00:08:53
Episode Cover

Researching Performance, Postgres Survey, pgAdmin Survey, Long Running Queries | Scaling Postgres 227

In this episode of Scaling Postgres, we discuss PG14's new SQL function In this episode of Scaling Postgres, we discuss research into a performance...

Listen

Episode 412

April 12, 2026 00:15:31
Episode Cover

Half as Fast on Linux 7 | Scaling Postgres 412

In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is...

Listen