On Fri, 8 Mar 2002, Gregory Wood wrote:
> > Do sequential scans go over the entire space, including the space not in
> > use? It would be great if there was some kind of optimization that could
> > move the empty space towards the end. It would probably be an expensive
> > operation, but it may be very helpfull on databases with a big turnaround.
>
> The only difference between doing that and doing a VACUUM FULL would be that
> the disk usage would remain the same.
There is one other extremely important difference. VACUUM FULL locks the
table/database.
> Personally, I would continue do the entire database once a week, and select
> a few key tables that have a lot of UPDATEs/DELETEs to do daily
thanks like a reasonable thing to do.