Re: pg_basebackup blocking all queries with horrible performance

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: "Welty, Richard" <rwelty(at)ltionline(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, Jerry Sievers <gsievers19(at)comcast(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_basebackup blocking all queries with horrible performance
Date: 2012-06-20 14:06:30
Message-ID: CAP=oouHXYFjohM0dxVp8Qw=4C7BPmdVAHYf-gQ=aCkSmyw8_nA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On Wed, Jun 20, 2012 at 6:56 AM, Welty, Richard <rwelty(at)ltionline(dot)com> wrote:
> Lonni J Friedman writes:
>
>>I'm not using SSL.
>
> ummm, ssh uses ssl.
>

Sure, although I thought that Simon was referring to the database
itself. However, I don't think ssh is the problem, as I can scp a
file from the server and the load doesn't go crazy, nor does the
database ground to a halt.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig Ringer 2012-06-20 14:39:41 Re: Issue in save and retreive file in postgres
Previous Message Welty, Richard 2012-06-20 13:56:38 Re: pg_basebackup blocking all queries with horrible performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-06-20 14:08:11 Re: [PATCH 10/16] Introduce the concept that wal has a 'origin' node
Previous Message Andres Freund 2012-06-20 14:05:43 Re: [PATCH 10/16] Introduce the concept that wal has a 'origin' node