From: Jerry Sievers <gsievers19@comcast.net>
To: Lonni J Friedman <netllama@gmail.com>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_basebackup blocking all queries with horrible performance
Date: Thu, 07 Jun 2012 20:07:24 -0400
Message-ID: <874nqmy8cj.fsf@comcast.net> (raw)
In-Reply-To: <CAP=oouGeFVeDvEFa6DXf1YBwv-23rAh0PZ-5xOcezAFspC+gGg@mail.gmail.com>
References: <CAP=oouEy9xxa6biSnqNSJKMf0fuKsufiYjbz5SJyvj0gc0Qkiw@mail.gmail.com>
<CAP=oouEu0sRCTvk+99wr-k3HG1vN3pyL4PXvVPQ+UZcAz6x2_g@mail.gmail.com>
<CABUevEw9ax5SLaQYjf56gFM82SOfROMHHtWXQiMkbxVPrvxAFw@mail.gmail.com>
<CAP=oouGeFVeDvEFa6DXf1YBwv-23rAh0PZ-5xOcezAFspC+gGg@mail.gmail.com>
Lonni J Friedman <netllama@gmail.com> writes:
> On Thu, Jun 7, 2012 at 12:40 PM, Magnus Hagander <magnus@hagander.net> wrote:
>
>> On Thu, Jun 7, 2012 at 8:04 PM, Lonni J Friedman <netllama@gmail.com> wrote:
>>> 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.
>>>
>>
>> My guess would be that you are overloading your I/O system. You should
>> look at values from iostat and vmstat from when the system works fine
>> and when you run pg_basebackup, that should give you a hint in the
>> right direction.
>
> ok, thanks. i'll take a look at that. If this turns out to be the
> issue, is there some way to get pg_basebackup to run more slowly, so
> that it has less impact? Or could I do this with ionice on the
> pg_basebackup process?
You might try stopping pg_basebackup in place with SIGSTOP and check
if problem goes away. SIGCONT and you should start having
sluggishness again.
If verified, then any sort of throttling mechanism should work.
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 732.216.7255
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-admin@postgresql.org
Cc: gsievers19@comcast.net, netllama@gmail.com, magnus@hagander.net
Subject: Re: pg_basebackup blocking all queries with horrible performance
In-Reply-To: <874nqmy8cj.fsf@comcast.net>
* 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