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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.
*************************************************************************

Browse pgsql-hackers by date

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