Four Million TPS | Scaling Postgres 324

In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres and an introduction to window functions.

Content Discussed

• Four million TPS
• Why PostgreSQL prefers MergeJoin to HashJoin?
• Parallel Queries in Postgres
• Gentle Introduction to Window Functions in PostgreSQL
• Check Your Privileges
• Say hello to the Talking Postgres podcast
• Mentoring Program Updates
• CloudNativePG Recipe 9 - Inspecting the network and the storage in a CloudNativePG cluster
• CloudNativePG – Storage
• Using AI to generate data structures for PostgreSQL
• PostgreSQL and UUID as primary key
• Automated Major Version Upgrades in Percona Operator for PostgreSQL
• Grant Zhou
• Guide to Auditing and Monitoring Access in PostgreSQL
• Access Controls in PostgreSQL
• Introducing Go SQL/JSON Path and Playground
• Understanding Serverless PostgreSQL
• PGDay Lowlands and DBA Day 2024
• Crunchy Bridge Adds Iceberg to Postgres & Powerful Analytics Features

YouTube Video

Podcast Audio