Re: [PERFORM] Could synchronous streaming replication really degrade the performance of the primary?

head of sync rep by using pgbench, the overhead of throughput was less than 10%. When measuring sync rep, I used two set of physical machine and storage for the master and standby, and used 1Gbps network between them. Regards, -- Fujii Masao -- Sent via pgsql-performance mailing list (pgsql-p

Re: [PERFORM] pg_xlog size

ir on the slave node > archive_timeout = 30 Since the setting "archive_timeout" makes the server create new WAL segment file for each 30 seconds (even if there is no write transaction), the size of pg_xlog directory continuously grows up. Regards, -- Fujii Masao NIPPON TELEGR

Re: [PERFORM] Postgres replication

to this > virtual IP and then pgpool will distribute the connections to both systems > from there. How about pgpool-HA? It's a script that integrates pgpool and heartbeat. http://pgfoundry.org/projects/pgpool/ -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Soft