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:
2012-06-07 17:41:36 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-07 18:01:37 from Fabricio <fabrixio1(at)hotmail(dot)com>
2012-06-12 14:27:43 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-07 18:04:53 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-07 19:40:45 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-07 20:08:27 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-08 00:07:24 from Jerry Sievers <gsievers19(at)comcast(dot)net>
2012-06-08 01:01:46 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-08 06:04:41 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
2012-06-08 19:30:48 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-09 02:29:36 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-09 12:51:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-06-10 10:43:32 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-10 12:25:38 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-10 13:34:06 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-10 14:08:58 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-10 14:10:46 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-10 14:29:47 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-10 14:45:57 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-11 15:47:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-11 16:06:58 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-20 11:18:23 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-20 18:18:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-06-27 17:24:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-27 17:58:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-06-29 10:04:39 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-29 10:22:18 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-07-01 17:14:25 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-07-01 19:01:12 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-07-02 18:17:16 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-07-04 13:26:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-20 11:58:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-06-11 13:19:12 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-11 17:37:41 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-12 17:49:11 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-06-12 18:37:42 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-12 18:39:23 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-06-20 12:02:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-06-20 13:27:17 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-20 13:56:38 from "Welty, Richard" <rwelty(at)ltionline(dot)com>
2012-06-20 14:06:30 from Lonni J Friedman <netllama(at)gmail(dot)com>
2012-06-09 06:53:35 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Lists:
pgsql-admin pgsql-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:44Subject : Re: log_newpage header commentPrevious :From : Tom LaneDate : 2012-06-09 12:43:42Subject : Re: Avoiding adjacent checkpoint records
pgsql-admin by date
Next :From: truongxuan quangDate: 2012-06-09 15:00:44Subject : Previous :From : Scott MarloweDate : 2012-06-09 06:53:35Subject : Re: pg_basebackup blocking all queries with horrible performance
