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

Re: pg_basebackup blocking all queries with horrible performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Lonni J Friedman <netllama(at)gmail(dot)com>, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, Jerry Sievers <gsievers19(at)comcast(dot)net>, Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_basebackup blocking all queries with horrible performance
Date: 2012-06-09 12:51:10
Message-ID: 26788.1339246270@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Fujii Masao <masao(dot)fujii(at)gmail(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2012-06-09 14:49:44
Subject: Re: log_newpage header comment
Previous:From: Tom LaneDate: 2012-06-09 12:43:42
Subject: Re: Avoiding adjacent checkpoint records

pgsql-admin by date

Next:From: truongxuan quangDate: 2012-06-09 15:00:44
Subject:
Previous:From: Scott MarloweDate: 2012-06-09 06:53:35
Subject: Re: pg_basebackup blocking all queries with horrible performance

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