pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: Lonni J Friedman <netllama@gmail.com>
Cc: Craig Ringer <ringerc@ringerc.id.au>
Cc: Jerry Sievers <gsievers19@comcast.net>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_basebackup blocking all queries with horrible performance
Date: Sat, 09 Jun 2012 08:51:10 -0400
Message-ID: <26788.1339246270@sss.pgh.pa.us> (raw)
In-Reply-To: <CAHGQGwERsw_mmXcEktbkSC01cUs3-SXfQbNq5y5JDbMe8B=9RA@mail.gmail.com>
References: <CAP=oouEy9xxa6biSnqNSJKMf0fuKsufiYjbz5SJyvj0gc0Qkiw@mail.gmail.com>
	<CAP=oouEu0sRCTvk+99wr-k3HG1vN3pyL4PXvVPQ+UZcAz6x2_g@mail.gmail.com>
	<CABUevEw9ax5SLaQYjf56gFM82SOfROMHHtWXQiMkbxVPrvxAFw@mail.gmail.com>
	<CAP=oouGeFVeDvEFa6DXf1YBwv-23rAh0PZ-5xOcezAFspC+gGg@mail.gmail.com>
	<874nqmy8cj.fsf@comcast.net>
	<CAP=oouF_gTLJvxQ8tK8czZ_wRF3Xt63j40LJnBfbHE26qfOYgg@mail.gmail.com>
	<4FD195F9.8080108@ringerc.id.au>
	<CAP=oouGZ4=B8fg6694urDoL-E7SsksOuTZGXmP_6UQ3T67vj5w@mail.gmail.com>
	<CAHGQGwERsw_mmXcEktbkSC01cUs3-SXfQbNq5y5JDbMe8B=9RA@mail.gmail.com>

Fujii Masao <masao.fujii@gmail.com> writes:
> This seems a bug. I think we should prevent pg_basebackup from
> becoming synchronous standby. Thought?

Absolutely.  If we have replication clients that are not actually
capable of being standbys, there *must* be a way for the master
to know that.

			regards, tom lane



view thread (40+ messages)  latest in thread

Message-ID: <26788.1339246270@sss.pgh.pa.us>
Permalink:  ../26788.1339246270@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/26788.1339246270@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, masao.fujii@gmail.com, netllama@gmail.com, ringerc@ringerc.id.au, gsievers19@comcast.net, magnus@hagander.net
  Subject: Re: pg_basebackup blocking all queries with horrible performance
  In-Reply-To: <26788.1339246270@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox