Horton

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

Magnus Hagander <magnus@hagander.net>

View thread
From: Magnus Hagander <magnus@hagander.net>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Fujii Masao <masao.fujii@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Lonni J Friedman <netllama@gmail.com>, Craig Ringer <ringerc@ringerc.id.au>, Jerry Sievers <gsievers19@comcast.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-06-29T10:04:39Z
Lists: pgsql-hackers 
On Wed, Jun 27, 2012 at 7:58 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 27 June 2012 18:24, Fujii Masao <masao.fujii@gmail.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/