Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1744564FD92 for ; Mon, 17 Nov 2008 11:30:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83418-03 for ; Mon, 17 Nov 2008 11:30:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137079.authsmtp.co.uk (outmail137079.authsmtp.co.uk [62.13.137.79]) by mail.postgresql.org (Postfix) with ESMTP id BB6876500AC for ; Mon, 17 Nov 2008 11:30:52 -0400 (AST) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt4.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mAHFUIHm074536; Mon, 17 Nov 2008 15:30:18 GMT Received: from [192.168.0.3] (85-211-229-157.dyn.gotadsl.co.uk [85.211.229.157]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mAHFUGBN023972; Mon, 17 Nov 2008 15:30:17 GMT Subject: Re: [PATCHES] Infrastructure changes for recovery (v8) From: Simon Riggs To: Heikki Linnakangas Cc: pgsql-hackers In-Reply-To: <492176E2.1000006@enterprisedb.com> References: <1222815151.4445.1397.camel@ebony.2ndQuadrant> <48EC9CC5.6060803@enterprisedb.com> <1223468660.4747.294.camel@ebony.2ndQuadrant> <1223472898.4747.310.camel@ebony.2ndQuadrant> <492176E2.1000006@enterprisedb.com> Content-Type: text/plain Date: Mon, 17 Nov 2008 15:31:16 +0000 Message-Id: <1226935876.3790.10.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: a2f6a84b-b4bc-11dd-8a51-002264978518 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaQJbY1ZH HGQLW1xEUVh7WmN/ ag0fZQBDYEtPQQdo WVZIR1VNFgBqBAMB SENvKm8XAHc4eHxz bEFgEHFeVUw0JEQr RB9cET8bN2MyO30e URQMagsFdQJXfh9H aFZ7XXQFZGQPKBg1 TUcABxkNFhVyExEd YwcDN1sJXVwWFSIh XR1KFjUmG0IIXG09 KAZuMFMXG1gcKFR6 cUVxGDpf X-Authentic-SMTP: 61633235383639.pelican.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/1149 X-Sequence-Number: 127861 On Mon, 2008-11-17 at 15:51 +0200, Heikki Linnakangas wrote: > Simon Riggs wrote: > > diff --git a/src/backend/access/transam/subtrans.c b/src/backend/access/transam/ > > index 063b366..5e64cb4 100644 > > --- a/src/backend/access/transam/subtrans.c > > +++ b/src/backend/access/transam/subtrans.c > > @@ -226,6 +226,9 @@ ZeroSUBTRANSPage(int pageno) > > * > > * oldestActiveXID is the oldest XID of any prepared transaction, or nextXid > > * if there are none. > > + * > > + * Note that this is not atomic and is not yet safe to perform while other > > + * processes might access subtrans. > > */ > > void > > StartupSUBTRANS(TransactionId oldestActiveXID) > > I'm a bit confused by that comment. Does that need to be fixed? It is, in a later version. Apologies if you're reviewing the wrong one. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support