pgsql: Add third idea about pulling data from indexes.

Started by Bruce Momjianalmost 19 years ago1 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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)