Michael Riess <mlriess@xxxxxx> writes: > I'm curious as to why autovacuum is not designed to do full vacuum. Locking considerations. VACUUM FULL takes an exclusive lock, which blocks any foreground transactions that want to touch the table --- so it's really not the sort of thing you want being launched at unpredictable times. regards, tom lane
