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 195

December 13, 2021 • 00:18:31
Episode Cover

Aurora vs. Postgres, Surprising Transactions, Write-Only & Read-Only, Indexing Advice | Scaling Postgres 195

In this episode of Scaling Postgres, we discuss Aurora vs. Postgres, surprising transaction behavior, write-only & read-only database connections and indexing best practices. To...

Listen

Episode 56

March 24, 2019 • 00:10:35
Episode Cover

Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56

In this episode of Scaling Postgres, we review articles covering practical indexing, vertical scalability, migrating to partitions and foreign data wrapper performance. To get...

Listen

Episode 222

July 04, 2022 • 00:17:47
Episode Cover

Postgres 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies | Scaling Postgres 222

In this episode of Scaling Postgres, we discuss psql shortcuts, how to debug deadlocks, how to find & stop queries and how to understand...

Listen