Four million TPS

Nikolay talks Michael through a recent experiment to find the current maximum transactions per second single-node Postgres can achieve — why he was looking into it, what bottlenecks occurred along the way, and ideas for follow up experiments.

Here are some links to things they mentioned:
• How many TPS can we get from a single Postgres node? (Article by Nikolay) linkedin.com/pulse/how-many-tps-can-we-get-fro…
• Chat history with Postgres AI bot postgres.ai/chats/01905a83-4573-7dca-b47a-bb60…
• Our episode on the overhead of pg_stat_statements and pg_stat_kcache postgres.fm/episodes/overhead-of-pg_stat_state…
• PostgreSQL 17 beta 2 is out postgresql.org/about/news/postgresql-17-beta-2…
• PostgreSQL and MySQL: Millions of Queries per Second (about the work by Sveta and Alexander) percona.com/blog/millions-queries-per-second-p…
• postgresql_cluster github.com/vitabaks/postgresql_cluster
• Track on CPU events for pg_wait_sampling github.com/postgrespro/pg_wait_sampling/pull/74
• The year of the Lock Manager’s Revenge (post by Jeremy Schneider) ardentperf.com/2024/03/03/postgres-indexes-par…
• Pluggable cumulative statistics (Postgres hackers thread started by Michael Paquier) postgresql.org/message-id/flat/Zmqm9j5EO0I4W8d…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With special thanks to:
• Jessie Draws (jessiedraws.com) for the elephant artwork