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

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

pgsql-hackers by date

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

pgsql-admin by date

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

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