Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc.

Hi all, I have a general question on scaling PostgreSQL for unlimited throughput, based on some experience. TL;DR: My question is: given that the work-load on any secondary/standby database server is almost the same as that of the master database server, is there any point to bother with PgPoo

Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc.

Hello, I asked the same question to myself in the past years. I think that the question boils down to: How can I achieve unlimited database scalability? Is it possible to have linear scalability (i.e. throughput increases proportionally to the number of nodes)? The answer is "sharding". It can

Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc.

On Wed, Dec 23, 2020 at 07:34:01PM +0100, Marco Colli wrote: >  Hello, > > I asked the same question to myself in the past years. > > I think that the question boils down to:  > How can I achieve unlimited database scalability?  > Is it possible to have linear scalability (i.e. throughput increas