[pgpool-general: 2032] pgpool replication mode

Garry Saddington garry at scholarpack.com
Thu Aug 15 01:16:15 JST 2013


I'm very interested in using the replication mode as provided by pgpool but have some questions that are worrying me.

1/ What sort of overhead does it add if used instead of streaming replication.
2/How are things like nextval handled so that each backend is in synch? Especially when selects are load balanced.
3/Are there diminishing returns on adding more backends.

We want to scale as we get more clients, any advice would be appreciated. What is the best way to scale a postgresql based web app.

Thanks in anticipation.
Garry


More information about the pgpool-general mailing list