SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL

Re:SPQR 1.3.0: a production-ready system for horizontal scal... by hot_gril on Monday March 25, 2024 @06:36PM (#39822026)

What I meant is, even if processes had no cost, you will probably bottleneck on the I/O. So it doesn't matter a lot how many Postgres connections you have.

[ Parent | on HN ]

Re:SPQR 1.3.0: a production-ready system for horizontal scal... by ManBeardPc on Tuesday March 26, 2024 @05:18AM (#39825709)

Sure, it’s not the most common problem to experience, just something that’s useful to know once you have more and more clients. It did happen to me, all connections used up for long running transactions (for multiple reasons) and then nothing else was able to run, CPU and I/O nearly idling at <5%, no significant lock contention.

[ Parent | on HN ]

Re:SPQR 1.3.0: a production-ready system for horizontal scal... by hot_gril on Tuesday March 26, 2024 @06:15PM (#39833465)

Ah, long-running transactions wreak havoc with connection pools.

[ Parent | on HN ]