pgsql: Add third idea about pulling data from indexes.

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add third idea about pulling data from indexes.
Date: 2007-08-15 15:53:30
Message-ID: 20070815155330.53301754259@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add third idea about pulling data from indexes.

> A third idea would be for a heap scan to check if all rows are visible
> and if so set a per-table flag which can be checked by index scans.
> Any change to the table would have to clear the flag. To detect
> changes during the heap scan a counter could be set at the start and
> checked at the end --- if it is the same, the table has not been
> modified --- any table change would increment the counter.

Modified Files:
--------------
pgsql/doc/src/FAQ:
TODO.html (r1.711 -> r1.712)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.711&r2=1.712)

Browse pgsql-committers by date

  From Date Subject
Next Message User Mha 2007-08-15 19:01:27 pginstaller - web: Fix spelling error, per Leoj in pgsql bug report
Previous Message Bruce Momjian 2007-08-15 15:36:31 pgsql: Fix whitespace in TODO.