Fix logic in lazy vacuum to decide if it's worth trying to truncate the heap.
Heikki Linnakangas <heikki.linnakangas@iki.fi>
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
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/vacuumlazy.c | modified | +4 −3 |