Re: pg_basebackup blocking all queries with horrible performance - Mailing list pgsql-admin

From Lonni J Friedman
Subject Re: pg_basebackup blocking all queries with horrible performance
Date
Msg-id CAP=oouEu0sRCTvk+99wr-k3HG1vN3pyL4PXvVPQ+UZcAz6x2_g@mail.gmail.com
Whole thread Raw
In response to pg_basebackup blocking all queries with horrible performance  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: pg_basebackup blocking all queries with horrible performance  (Magnus Hagander <magnus@hagander.net>)
List pgsql-admin
On Thu, Jun 7, 2012 at 10:41 AM, Lonni J Friedman <netllama@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 running
> Fedora-16-x86_64.
>
> http://wiki.postgresql.org/wiki/Lock_Monitoring

err, i included that URL but neglected to explain why.  On a different
list someone suggested that I verify that there were no locks that
were blocking things, and I did so, and found no locks.

So I'm still at a loss why pg_basebackup is killing perf, and would
appreciate pointers on how to debug it or at least reduce its impact
on performance if that is possible.

tahnks

pgsql-admin by date:

Previous
From: Fabricio
Date:
Subject: could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or directory
Next
From: Amador Alvarez
Date:
Subject: Re: Can schemas be ordered regarding their creation time ?