Four million TPS | Postgres.FM 104 |

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

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)   / how-many-tps-can-we-get-from-single-postgr...  
* Chat history with Postgres AI bot https://postgres.ai/chats/01905a83-45...
* Our episode on the overhead of pg_stat_statements and pg_stat_kcache https://postgres.fm/episodes/overhead...
* PostgreSQL 17 beta 2 is out https://www.postgresql.org/about/news...
* PostgreSQL and MySQL: Millions of Queries per Second (about the work by Sveta and Alexander) https://www.percona.com/blog/millions...
* postgresql_cluster https://github.com/vitabaks/postgresq...
* Track on CPU events for pg_wait_sampling https://github.com/postgrespro/pg_wai...
* The year of the Lock Manager’s Revenge (post by Jeremy Schneider) https://ardentperf.com/2024/03/03/pos...
* Pluggable cumulative statistics (Postgres hackers thread started by Michael Paquier) https://www.postgresql.org/message-id...


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
- Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.