Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group