I'm still plagued by this. Immediately before starting a basebackup
the load on my server is 1.00 or less. Within a few minutes of
starting the basebackup, the load climbs steadily to 30+ and anything
trying to write to the database just sits for minutes at a time, with
overall performance on
Greetings,
I have a 4 server postgresql-9.1.3 cluster (one master doing streaming
replication to 3 hot standby servers). All of them are running
Fedora-16-x86_64. Last Friday I upgraded the entire cluster from
Fedora-15 with postgresql-9.0.6 to Fedora-16 with postgresql-9.1.3.
I'm finding that
Do the queries here help?
http://wiki.postgresql.org/wiki/Lock_Monitoring
On Tue, May 22, 2012 at 12:42 PM, Lonni J Friedman netll...@gmail.com wrote:
Greetings,
I have a 4 server postgresql-9.1.3 cluster (one master doing streaming
replication to 3 hot standby servers). All of them are
Thanks for your reply. Unfortunately, those queries don't shed any
light no the problem. The first two return 0 rows, and the third just
returns 12 rows all associated with the query itself, rather than
anything else.
Any other suggestions?
On Tue, May 22, 2012 at 2:56 PM, Scott Marlowe