From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>,
Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Keepalive for max_standby_delay
Date:
2010-07-03 20:18:11
Message-ID:
14694.1278188291@sss.pgh.pa.us (view raw or flat )
Thread:
2010-05-15 13:17:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-15 15:45:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-05-15 16:23:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-15 16:30:38 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-15 16:49:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-15 17:05:41 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-15 17:24:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-15 18:50:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-15 20:08:20 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-15 21:05:49 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-16 15:53:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-17 08:40:50 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-18 21:06:26 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-18 21:17:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-18 21:25:46 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-18 21:37:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 22:34:59 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-26 22:44:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 22:45:09 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-05-26 22:52:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 23:22:40 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-05-27 17:26:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-31 18:40:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-02 16:41:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-02 16:59:05 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-06-01 10:36:59 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-01 11:04:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-02 17:14:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 17:36:52 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-06-02 17:45:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 18:03:50 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-02 18:13:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-02 17:44:26 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-02 18:23:44 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-02 19:14:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 22:59:23 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-02 23:11:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 00:47:10 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-06-03 15:07:10 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-03 15:18:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 15:27:51 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-03 15:34:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 15:43:54 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-02 18:27:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-02 18:35:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-03 16:47:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 17:18:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-03 17:32:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 17:46:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-03 22:48:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-03 23:02:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-09 22:52:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-10 00:01:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-17 01:49:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-17 01:56:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-17 02:03:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-21 04:20:33 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2010-06-21 12:53:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-28 07:17:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-28 14:03:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-28 14:19:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-28 17:09:40 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-06-30 19:08:16 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-30 21:57:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-28 17:24:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-28 18:26:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-28 18:55:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-07-02 20:11:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-07-02 20:20:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-07-02 20:36:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-07-02 20:40:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-07-02 20:52:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-07-02 21:01:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-07-03 11:59:10 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-07-03 15:32:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-07-03 19:17:48 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-07-03 20:18:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 18:44:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 19:14:45 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-02 19:21:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 09:18:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-03 13:47:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 19:40:21 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-02 19:50:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 20:20:08 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-02 20:53:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-03 15:26:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 19:41:49 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-02 20:00:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 07:56:54 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-03 16:58:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-03 12:14:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-03 08:56:49 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-03 09:07:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-03 09:39:48 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-03 10:57:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-17 02:18:37 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-16 16:11:35 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-17 02:51:13 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-17 07:07:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 22:47:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-17 16:36:07 from Jim Nasby <decibel(at)decibel(dot)org>
2010-05-18 21:08:13 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-18 21:21:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
Lists:
pgsql-hackers
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> On 03/07/10 18:32, Tom Lane wrote:
>> That would not do what you want at all in the case where you're
>> recovering from archive --- XLogReceiptTime would never advance
>> at all for the duration of the recovery.
> Do you mean when using something like pg_standby, which does the waiting
> itself?
No, I'm thinking about recovery starting from an old base backup, or any
situation where you're trying to process a significant number of
archived WAL segments as quickly as possible.
>> It might be useful if you knew that it was a standby-with-log-shipping
>> situation, but we have no way to tell the difference.
> With pg_standby etc. you use standby_mode=off. Same with traditional
> archive recovery. In standby mode, it's on.
Uh, no, that parameter is not what I'm talking about. What I tried to
say is that if you're using log shipping for replication instead of
walsender/walreceiver, you might want to treat data as live even though
the database thinks it is being pulled "from archive". But we'd need
a way for the database to tell the cases apart ... right now it cannot.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-07-03 22:41:22Subject : Re: Why are these modules built without respecting my LDFLAGS? Previous :From : Robert HaasDate : 2010-07-03 19:34:37Subject : Re: Keeping separate WAL segments for each database
