From: Antonin Faltynek <pin007@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Streaming replication performance
Date: Thu, 11 Aug 2011 16:46:38 +0200
Message-ID: <201108111646.39321.pin007@gmail.com> (raw)
Hi all,
I'm testing Streamin replication with one hot standby node and I'm
experiencing high delay of hot standby node.
When I reach aprox. 50 transactions per second where every transaction
includes only simple "UPDATE status SET number = number + 1 WHERE name =
'iterations'", the standby server falls behind master and the delay is several
minutes. In comparison, Slony1 have no issues with the same test and its delay
is only several seconds.
Am I missing some configuration that affects speed of streaming replicaiton?
Both servers are connected using 1Gb network, CPU usage of both servers is
low, disk latency is not issue.
master server postgresql.conf
-----
wal_level = 'hot_standby'
vacuum_defer_cleanup_age = 10000
checkpoint_segments = 8
checkpoint_timeout = 30s
archive_mode = off
max_wal_senders = 3
wal_sender_delay = 10ms
wal_keep_segments = 128
-----
standby server postgresql.conf
-----
hot_standby = on
max_standby_streaming_delay = 30s
-----
standby server recovery.conf
-----
standby_mode = 'on'
primary_conninfo = 'host=master port=5432 user=replication2 password=password'
trigger_file = '/var/lib/postgresql/9.0/main/replica_trigger'
-----
Thank you for any advice
Antonin Faltynek
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pin007@gmail.com
Subject: Re: Streaming replication performance
In-Reply-To: <201108111646.39321.pin007@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox