]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix logic in lazy vacuum to decide if it's worth trying to truncate the heap.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Tue, 6 Jan 2009 14:55:50 +0000 (14:55 +0000)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Tue, 6 Jan 2009 14:55:50 +0000 (14:55 +0000)
commit17409471b5384d8e4e5ec3228672ce2fbcabff43
treec0105e306cb047f735ee62e610adea8e67e2e98c
parente4dcb11ead8f4109f2b97aaef93807f1fcba818f
Fix logic in lazy vacuum to decide if it's worth trying to truncate the heap.
If the table was smaller than REL_TRUNCATE_FRACTION (= 16) pages, we always
tried to acquire AccessExclusiveLock on it even if there was no empty pages
at the end.

Report by Simon Riggs. Back-patch all the way to 7.4.
src/backend/commands/vacuumlazy.c