Обсуждение: PITR, nested transactions, tablespaces, 2-phase commit: Status request

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

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 

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