Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 5ff95e6

Browse filesBrowse files
committed
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.
1 parent 811f91c commit 5ff95e6
Copy full SHA for 5ff95e6

File tree

Expand file treeCollapse file tree

1 file changed

+8
-1
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+8
-1
lines changed

‎doc/src/FAQ/TODO.html

Copy file name to clipboardExpand all lines: doc/src/FAQ/TODO.html
+8-1Lines changed: 8 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Wed Aug 15 11:36:16 EDT 2007
11+
Last updated: Wed Aug 15 11:48:07 EDT 2007
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -1010,6 +1010,13 @@ <h1><a name="section_14">Cache Usage</a></h1>
10101010
add someday to determine which heap pages need vacuuming. Frequently
10111011
accessed bitmaps would have to be stored in shared memory. One 8k
10121012
page of bitmaps could track 512MB of heap pages.
1013+
</p>
1014+
<p> A third idea would be for a heap scan to check if all rows are visible
1015+
and if so set a per-table flag which can be checked by index scans.
1016+
Any change to the table would have to clear the flag. To detect
1017+
changes during the heap scan a counter could be set at the start and
1018+
checked at the end --- if it is the same, the table has not been
1019+
modified --- any table change would increment the counter.
10131020
</p>
10141021
</li><li>Consider automatic caching of statements at various levels:
10151022
<ul>

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.