[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