[pgpool-general: 8420] How to size pgPool server?
Ron
ronljohnsonjr at gmail.com
Mon Sep 19 23:00:20 JST 2022
Newbie question: how big should the phPool server be, compared to the
existing stand-alone PostgreSQL 9.6 server that we're adding pgPool on top of?
Background: my customer wants to HA and for the application to connect to
only one host name, no matter which of two replicated Postgres servers is
currently Primary. (Basically, to emulate SQL Server Availability Groups.)
Thus, I'm looking at pgPool-II.
Currently, the database server has X number of CPUs, and 132GB RAM. Of
course the (new) replicated database server will be the same size.
Specifically:
1. How big (CPU/RAM) should the pgPool server be, given the size of the
current server?
2. Can we reduce the size of database server?
3. How much disk space needed for pgPool besides log files?
Thanks.
--
Angular momentum makes the world go 'round.
More information about the pgpool-general
mailing list