Queues in Postgres
Postgres FM
00:00
The Importance of Queuing in Postgres
If you if you have multiple workers, you definitely can achieve many, many thousands of transactions per second on good hardware. That should be enough for most systems already these days, right? 99.99% I think. Well, obviously cases when we need more, but this is already good enough. So summary is below is our main enemy here, the top one below, and partitioning. Consider partitioning. Second is check, explain analyze buffers and have good plans for your queries. And finally, for a basket block.
Transcript
Play full episode
