From 3bea1a353f3ca18ff08e0a95739dcaae85d23bdc Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 2 Sep 2005 19:51:37 +0000 Subject: [PATCH] Update wording: < could only see committed rows from another transaction. However, > could only see rows from another completed transaction. However, 981c981 < proper visibility of the row, for example, for cursors. > proper visibility of the row's cmin, for example, for cursors. --- doc/TODO | 6 +++--- doc/src/FAQ/TODO.html | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/TODO b/doc/TODO index 488de148c3..d8c0adf5b1 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Fri Sep 2 15:39:11 EDT 2005 +Last updated: Fri Sep 2 15:51:34 EDT 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -972,13 +972,13 @@ Miscellaneous Performance xmax), cmin, cmax, and if the transaction was expiring a row from a another transaction, the fields stored were xmin (cmin was not needed), xmax, and cmax. Such a system worked because a transaction - could only see committed rows from another transaction. However, + could only see rows from another completed transaction. However, subtransactions can see rows from outer transactions, and once the subtransaction completes, the outer transaction continues, requiring the storage of all four fields. With subtransactions, an outer transaction can create a row, a subtransaction expire it, and when the subtransaction completes, the outer transaction still has to have - proper visibility of the row, for example, for cursors. + proper visibility of the row's cmin, for example, for cursors. One possible solution is to create a phantom cid which represents a cmin/cmax pair and is stored in local memory. diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 178ba0df80..50d99eb575 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Fri Sep 2 15:39:11 EDT 2005 +Last updated: Fri Sep 2 15:51:34 EDT 2005

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -876,13 +876,13 @@ first. xmax), cmin, cmax, and if the transaction was expiring a row from a another transaction, the fields stored were xmin (cmin was not needed), xmax, and cmax. Such a system worked because a transaction - could only see committed rows from another transaction. However, + could only see rows from another completed transaction. However, subtransactions can see rows from outer transactions, and once the subtransaction completes, the outer transaction continues, requiring the storage of all four fields. With subtransactions, an outer transaction can create a row, a subtransaction expire it, and when the subtransaction completes, the outer transaction still has to have - proper visibility of the row, for example, for cursors. + proper visibility of the row's cmin, for example, for cursors.

One possible solution is to create a phantom cid which represents a cmin/cmax pair and is stored in local memory. -- 2.40.0