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 any
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 wrote
Do the queries here help?
http://wiki.postgresql.org/wiki/Lock_Monitoring
On Tue, May 22, 2012 at 12:42 PM, Lonni J Friedman 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 running
> Fedora-16-
