X-Original-To: pgsql-hackers@postgresql.org Received: from grunt21.ihug.com.au (grunt21.ihug.com.au [203.109.249.141]) by postgresql.org (Postfix) with ESMTP id B5D88475E82 for ; Tue, 11 Mar 2003 02:24:28 -0500 (EST) Received: from 203-30-124-227.cust.iweb.net.au (postgresql.org) [203.30.124.227] by grunt21.ihug.com.au with esmtp (Exim 3.35 #1 (Debian)) id 18se7e-0000fB-00; Tue, 11 Mar 2003 18:24:26 +1100 Message-ID: <3E6D8F28.9060605@postgresql.org> Date: Tue, 11 Mar 2003 17:54:24 +1030 From: Justin Clift User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3b) Gecko/20030210 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-hackers@postgresql.org Subject: Re: Roadmap for FE/BE protocol redesign References: <19041.1047322279@sss.pgh.pa.us> <3E6CE1F2.8030302@postgresql.org> <19173.1047323837@sss.pgh.pa.us> In-Reply-To: <19173.1047323837@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/412 X-Sequence-Number: 36658 Tom Lane wrote: > Justin Clift writes: > >>The scenario that's appealing to me the most is this for the next release: >>PostgreSQL 8.0 >>+ Includes PITR and the Win32 port > > If the folks doing those things can get done in time, great. I'm even > willing to push out the release schedule (now, not later) to make it > more likely they can get done. What I'm not willing to do is define > the release in terms of "it happens when these things are done". We > learned the folly of that approach in 7.1 and 7.2. Setting a target > date and sticking to it works *much* better. Yep, we both seem to be saying that we'd like these features, but we don't want to see them become delay-points. >>+ Not sure where Satoshi is up to with his 2 phase commit proposal, but >>that might make sense to incorporate into a wire protocol revision. > > I can't see any need for protocol-level support for such a thing. > Why wouldn't it just be some more SQL commands? Not sure. It seems like 2PC will be required/desirable within the year for better support of some clustering scenarios, so we "might as well look at it now". When I was reading Satoshi's stuff a while ago I thought it was a protcol level thing, not a SQL command level thing, but don't really care either way. :) Regards and best wishes, Justin Clift > (Not that I believe in 2PC as a real-world solution anyway, but that's > a different argument...) > > regards, tom lane -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi