aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/funcs.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-09-16 02:37:54 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-09-16 02:37:54 +0000
commit3d446c476748a9e384e70bd09026cbdbd34a9bf2 (patch)
tree88685d1af4692423880b71504b7eb4a14ca9466f /src/tutorial/funcs.c
parent67bc5b0ca335cde3d1867135ed4997e0273c8595 (diff)
downloadpostgresql-3d446c476748a9e384e70bd09026cbdbd34a9bf2.tar.gz
postgresql-3d446c476748a9e384e70bd09026cbdbd34a9bf2.zip
Fix aboriginal mistake in lazy VACUUM's code for truncating away
no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports.
Diffstat (limited to 'src/tutorial/funcs.c')
0 files changed, 0 insertions, 0 deletions