Fix logic in lazy vacuum to decide if it's worth trying to truncate the heap.

Heikki Linnakangas <heikki.linnakangas@iki.fi>

Commit: fcd3890f3c8fb63a7a2fe1732f0b412b65f45c5e
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2009-01-06T14:55:56Z
Releases: 8.1.16
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.

Files

PathChange+/−
src/backend/commands/vacuumlazy.c modified +4 −3