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

2020-12-23 Thread Bruce Momjian
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.

2020-12-23 Thread Marco Colli
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