Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D577E6326FA for ; Tue, 6 Oct 2009 04:27:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12524-02 for ; Tue, 6 Oct 2009 07:27:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128067.authsmtp.com (outmail128067.authsmtp.com [62.13.128.67]) by mail.postgresql.org (Postfix) with ESMTP id AEBB16324D1 for ; Tue, 6 Oct 2009 04:27:43 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt10.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n967Rduv040916; Tue, 6 Oct 2009 08:27:39 +0100 (BST) Received: from [192.168.0.5] (88-110-238-233.dynamic.dsl.as9105.com [88.110.238.233]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n967RaHr050526; Tue, 6 Oct 2009 08:27:36 +0100 (BST) Subject: Re: Hot Standby on git From: Simon Riggs To: Heikki Linnakangas Cc: pgsql-hackers In-Reply-To: <4ABF4522.6060601@enterprisedb.com> References: <1253958559.4449.833.camel@ebony.2ndQuadrant> <4ABF4522.6060601@enterprisedb.com> Content-Type: text/plain Date: Tue, 06 Oct 2009 08:31:27 +0100 Message-Id: <1254814287.26302.49.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: b8907627-b249-11de-9488-0022640b883e X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaANbYlpF HGQLW11EUFV7W2R/ aAwfZQ1DY0tOQQdp WFZLQVFNFgBqBAMB SEAXVB4QJn0EeHtw YERkEHVdXkw0J050 QklSF2obN2VkYX0e URQNagpQeAtXfh9H aFZ7VCEFaWZSKBg1 TUcAHxkaHhhlExEd YgYRZWkOSEAHFC90 QBZKEjQzdQAA X-Authentic-SMTP: 61633235383639.1015:706/Kp 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=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/383 X-Sequence-Number: 147195 On Sun, 2009-09-27 at 13:57 +0300, Heikki Linnakangas wrote: > Per Simon's request, for the benefit of the archive, here's all the > changes I've done on the patch since he posted the initial version for > review for this commitfest as incremental patches. This is extracted > from my git repository at > git://git.postgresql.org/git/users/heikki/postgres.git. There were 16 change patches included in this post. I have applied 14 of them, almost all without any changes to comment or code. I've fixed 2 bugs and made changes where XXX comments were left in code. That leaves 0011-locks... discussed on another part of this thread and patch 0005-Include-information... which I'm discussing here. It's a huge set of changes, all of which is just refactoring, none of which is a bug fix of any kind. The refactoring does sound reasonable, but is really fairly minor. I feel we should defer this change for the future to allow us to stabilise the current patch. I do understand the need for refactoring, but if we refactor everything touched by Hot Standby then we will simply touch more code and trigger more bugs etc.. This is especially true with prepared transactions, which aren't well understood and not covered by as many tests. --- src/backend/access/transam/twophase.c | 96 +++++++++++++++++----------- src/backend/access/transam/twophase_rmgr.c | 13 ---- src/backend/access/transam/xact.c | 64 +++++++------------ src/backend/access/transam/xlog.c | 5 +- src/backend/commands/discard.c | 3 +- src/backend/commands/sequence.c | 3 + src/backend/storage/lmgr/lock.c | 5 +- src/backend/tcop/postgres.c | 1 + src/backend/utils/cache/inval.c | 90 ++------------------------ src/include/access/subtrans.h | 3 - src/include/access/twophase.h | 2 - src/include/access/twophase_rmgr.h | 6 +- src/include/access/xact.h | 6 -- src/include/miscadmin.h | 7 -- src/include/storage/proc.h | 7 +- src/include/utils/inval.h | 7 ++ 16 files changed, 108 insertions(+), 210 deletions(-) -- Simon Riggs www.2ndQuadrant.com