Re: Anyone know why PostgreSQL doesn't support 2 phase - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Anyone know why PostgreSQL doesn't support 2 phase
Date
Msg-id 3E942A99.A6102F2D@Yahoo.com
Whole thread Raw
In response to Re: Anyone know why PostgreSQL doesn't support 2 phase execution?  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Ron Peacetree wrote:
> [...]
> The lack of two phase =commit= is a also a potential performance hit
> in comparison to DB products that have it, but the more important
> issue there is that there are SMP/distributed apps that really can't
> work acceptably unless a DB product has two phase commit.
> 
> The three "biggies" in DB land, SQL Server, Oracle, and DB2, have both
> features.  I suspect that PostgreSQL will need to as well...

Ron, do you actually have some ideas how to do 2 phase commits?
Especially things like how to re-lock during startup after a crash and
the like? Or is your knowledge in reality only buzzwords collected from
high glossy tradeshow flyers?


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: [INTERFACES] More protocol discussion: breaking down
Next
From: Tom Lane
Date:
Subject: Re: pg_get_viewdef 7.4 et al