Hannu Krosing <[EMAIL PROTECTED]> writes: > meaning to VACUUM FULL the whole table, but to work in small chunks and > relaese all locks and let others access the tables between these ?
AFAICS this is impossible for VACUUM FULL. You can't let other accesses in and then resume processing, because that invalidates all the state you have about where to put moved tuples. But the whole point of developing non-FULL vacuuming was to make something that could be run concurrently with other stuff. I fail to see the point of insisting that frequent vacuums be FULL. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster