Skip site navigation (1) Skip section navigation (2)

Re: PITR, nested transactions, tablespaces, 2-phase commit:

From: Bob(dot)Henkel(at)hartfordlife(dot)com
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-hackers-owner(at)postgresql(dot)org
Subject: Re: PITR, nested transactions, tablespaces, 2-phase commit:
Date: 2004-04-23 18:30:55
Message-ID: OF0AC0A749.55946776-ON86256E7F.00659577-86256E7F.00659F66@hartfordlife.com (view raw or flat)
Thread:
Lists: pgsql-hackers




Just so you know I'm very thankful for your hard work and I'm sure many of
us are.  I have been waiting for this kind of functionally in Postgresql!


|---------+---------------------------------->
|         |           Heikki Linnakangas     |
|         |           <hlinnaka(at)iki(dot)fi>      |
|         |           Sent by:               |
|         |           pgsql-hackers-owner(at)pos|
|         |           tgresql.org            |
|         |                                  |
|         |                                  |
|         |           04/23/2004 12:56 PM    |
|         |                                  |
|---------+---------------------------------->
  >--------------------------------------------------------------------------------------------------------|
  |                                                                                                        |
  |       To:       pgsql-hackers(at)postgresql(dot)org                                                           |
  |       cc:                                                                                              |
  |       Subject:  Re: [HACKERS] PITR, nested transactions, tablespaces, 2-phase commit:     Status       |
  >--------------------------------------------------------------------------------------------------------|




On Sat, 17 Apr 2004, Bruce Momjian wrote:

> Would folks report on the current status of these projects:
>
>            o nested transactions (Alvaro Herrera)
>            o tablespaces (Gavin Sherry)
>            o PITR (Simon Riggs)
>            o 2-phase commit (Heikki Linnakangas)

I've been very busy with at work, and haven't had much time to work on the
2-phase commit patch.

I'm keeping a close eye on Alvaro's nested transactions stuff, because it
touches the same areas as 2-phase commits.

One day, while reading postgresql code, I realized that my two-phase
code doesn't do the right thing with snapshots. GetSnapshotData scans
through all running backends, and collects the xids of all running
transactions. I suppose all pre-committed transactions should go to the
snapshot too.

So there's still some work to be done, but I'm still hoping to finish it
in time for 7.5.

- Heikki


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
      message can get through to the mailing list cleanly






*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information.  If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited.  If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************


pgsql-hackers by date

Next:From: Rod TaylorDate: 2004-04-23 18:46:15
Subject: Re: contrib vs. gborg/pgfoundry for replication solutions
Previous:From: Andrew DunstanDate: 2004-04-23 18:28:10
Subject: Re: [pgsql-advocacy] What can we learn from MySQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group