]> granicus.if.org Git - postgresql/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:56 +0000 (14:55 +0000)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Tue, 6 Jan 2009 14:55:56 +0000 (14:55 +0000)
commitfcd3890f3c8fb63a7a2fe1732f0b412b65f45c5e
tree9a297a323e32cdb5e4dcf23bd4aea6c26c2be267
parentb27de223da1f64a23cf7934b78757b5fa073fbc4
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