Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lonni J Friedman <netllama(at)gmail(dot)com>, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, Jerry Sievers <gsievers19(at)comcast(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [ADMIN] pg_basebackup blocking all queries with horrible performance
Date: 2012-06-29 10:04:39
Message-ID: CABUevEwjhq1==Zqo904KrvuydgTVGbG1em3E9S+ekBtEkE__JQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On Wed, Jun 27, 2012 at 7:58 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On 27 June 2012 18:24, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>
>> will never become sync standby even
>> if their name is in synchronous_standby_names.
>
> I don't understand why you'd want that.
>
> What is wrong with removing the name from synchronous_standby_names if
> you don't like it?

I believe that's just fallout -the main point is that we don't want to
become a sync standby when synchronous_standby_names is set to '*'.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2012-06-29 10:22:18 Re: [ADMIN] pg_basebackup blocking all queries with horrible performance
Previous Message Albe Laurenz 2012-06-28 08:05:26 Re: terminating autovacuum process due to administrator command

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2012-06-29 10:22:18 Re: [ADMIN] pg_basebackup blocking all queries with horrible performance
Previous Message Eric McKeeth 2012-06-29 08:34:23 Re: Covering Indexes