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

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

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