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=oouFaJ82i+GZPCqLFmByhP3TY0XXYG7qPyiAnUF6h712HBA@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup blocking all queries with horrible performance  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
On Wed, Jun 20, 2012 at 5:02 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 13 June 2012 02:39, Magnus Hagander <magnus@hagander.net> wrote:
>
>>> I'm running the following, which gets piped over ssh to a remote
>>> server (at gigabit ethernet speed):
>>> pg_basebackup -v -D - -x -Ft -U postgres
>>>
>>> One thing that I've discovered is that if I throttle back the speed of
>>> what is getting piped to the remote server, that directly correlates
>>> to the load on the server.
>>
>> That seems to indicate that you're overloading the I/O system... Or
>> the CPU, but more likely I/O.
>
> CPU utilisation of ssl connections is bad. If network bandwidth is
> good, perhaps running WALSender at full speed with encryption can tank
> the server.

I'm not using SSL.

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pg_basebackup blocking all queries with horrible performance
Next
From: "Welty, Richard"
Date:
Subject: Re: pg_basebackup blocking all queries with horrible performance