From:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To:
Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Cc:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Synchronization levels in SR
Date:
2010-09-03 11:30:04
Message-ID:
AANLkTi=+F3dmiov3aomvPTX77dkCCqsX54OcDemwWjfs@mail.gmail.com (view raw or flat )
Thread:
2010-05-24 13:20:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-24 16:18:43 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-25 02:46:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-25 01:29:31 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-05-25 03:40:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-25 16:04:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 04:03:01 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-26 06:33:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 16:32:35 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 04:50:43 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-25 16:28:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 16:40:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-25 16:45:28 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-05-25 16:52:49 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-05-25 17:10:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 17:31:48 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-25 17:39:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 17:55:17 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 03:36:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-26 03:59:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-26 06:31:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 11:10:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-26 12:37:40 from Alastair Turner <bell(at)ctrlf5(dot)co(dot)za>
2010-05-26 13:54:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 15:31:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-26 16:55:30 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-26 17:10:22 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-05-26 17:24:47 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-26 17:33:01 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-05-26 17:49:14 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-26 18:01:03 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-05-26 17:41:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-26 17:27:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 17:40:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 18:02:13 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-26 20:31:04 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-05-26 21:21:32 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-26 22:23:05 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 23:18:12 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-27 06:51:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 07:09:16 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-27 09:12:36 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 21:38:36 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-27 09:01:04 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-05-27 20:31:46 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-05-27 22:47:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-04 00:47:31 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2010-06-04 02:57:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-04 13:51:39 from David Fetter <david(at)fetter(dot)org>
2010-06-04 19:35:52 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2010-06-04 20:22:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-04 20:27:17 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2010-06-02 07:22:42 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-06-02 09:25:20 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-02 14:31:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-02 17:37:59 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-06-02 09:36:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 21:31:40 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2010-05-26 22:00:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 17:26:28 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 18:30:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-26 19:13:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 19:37:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-26 19:41:13 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-05-26 08:02:22 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 09:52:10 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-26 13:20:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 02:28:43 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 06:21:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 07:35:39 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 09:30:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 10:21:13 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 10:33:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 11:13:27 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 11:30:21 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 12:10:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 19:53:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-05-26 13:37:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 07:13:45 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 09:48:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 10:21:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 10:50:34 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 11:30:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 12:21:36 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 11:28:52 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-09-03 09:43:32 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-03 11:30:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-03 12:57:33 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-06 12:53:07 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-09-06 19:45:10 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-06 20:04:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-06 20:11:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-06 22:34:05 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-06 20:32:24 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-06 21:02:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-06 22:07:23 from Greg Stark <gsstark(at)mit(dot)edu>
2010-09-06 22:31:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-06 23:49:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 06:39:34 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-08 10:04:15 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 10:38:01 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-08 10:52:09 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 11:43:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 12:30:34 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-08 13:07:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 13:32:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-08 13:50:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 14:22:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-08 14:38:47 from David Fetter <david(at)fetter(dot)org>
2010-09-08 14:53:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 12:47:35 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-08 12:56:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-27 11:28:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-27 12:02:56 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 12:48:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-05-27 13:09:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-05-27 13:44:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 08:01:20 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-07 12:16:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 13:45:00 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-07 14:15:13 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 14:31:05 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-07 15:06:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 16:00:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 17:50:48 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-07 15:17:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-07 15:29:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 15:43:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-07 15:55:49 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-07 18:12:54 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-09-07 20:06:03 from marcin mank <marcin(dot)mank(at)gmail(dot)com>
2010-09-07 20:08:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 14:47:33 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2010-09-07 15:31:06 from Markus Wanner <markus(at)bluegap(dot)ch>
2010-05-25 16:59:28 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 16:49:06 from MMK <bomuvi(at)yahoo(dot)com>
2010-05-25 17:36:32 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-05-25 19:24:28 from MMK <bomuvi(at)yahoo(dot)com>
2010-05-25 20:54:29 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-05-25 17:08:13 from Alastair Turner <bell(at)ctrlf5(dot)co(dot)za>
2010-05-25 17:42:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-25 19:19:36 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2010-05-25 20:16:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-05-26 00:58:01 from Florian Pflug <fgp(at)phlo(dot)org>
2010-05-25 19:20:03 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Lists:
pgsql-hackers
On Fri, Sep 3, 2010 at 6:43 PM, Boszormenyi Zoltan <zb(at)cybertec(dot)at> wrote:
> In my patch, when the transactions were waiting for ack from
> the standby, they have already released all their locks, the wait
> happened at the latest possible point in CommitTransaction().
>
> In Fujii's patch (I am looking at synch_rep_0722.patch, is there
> a newer one?)
No ;)
We'll have to create the patch based on the result of the recent
discussion held on other thread.
> the wait happens in RecordTransactionCommit()
> so other transactions still see the sync transaction and most
> importantly, the locks held by the sync transaction will make
> the async transactions waiting for the same lock wait too.
The transaction should be invisible to other transactions until
its replication has been completed. So I put the wait before
CommitTransaction() calls ProcArrayEndTransaction(). Is this unsafe?
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Thom BrownDate: 2010-09-03 11:32:51Subject : Re: Streaming a base backup from masterPrevious :From : Magnus HaganderDate : 2010-09-03 11:30:02Subject : Re: Streaming a base backup from master
