Latest Episodes
355
Top Ten Analytics with pg_mooncake | Scaling Postgres 355
In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions,...
354
Postgres & The US Treasury Attack | Scaling Postgres 354
In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application...
353
OLTP To Parquet For Analytics | Scaling Postgres 353
In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining...
352
You Can Always Optimize More | Scaling Postgres 352
In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices. To...
351
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...
350
Seven Years of Scaling Postgres | Scaling Postgres 350
In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group...