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 182

September 12, 2021 00:13:50
Episode Cover

Boundless Text, Revoked Permissions, Index Bloat, Hardware Performance | Scaling Postgres 182

In this episode of Scaling Postgres, we discuss having boundless text fields, revoking public schema permissions, less index bloat in PG14 and comparing hardware...

Listen

Episode 358

March 23, 2025 00:23:37
Episode Cover

Postgres Conference 2025 | Scaling Postgres 358

In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly,...

Listen

Episode 318

June 02, 2024 00:17:54
Episode Cover

Postgres 17 Beta 1 Released | Scaling Postgres 318

In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it,...

Listen