Re: VACUUM Question

Rick Gigger <rick(at)alpinenetworking(dot)com> wrote:

> >>One more question; on one server the Vacuum Analyze before the insert takes
> >>approx. 2min after that the same command takes 15min.
> >
> >
> > You might try a VACUUM FULL sometime when you can deal with 15min of downtime
> > or so. Actually it would probably be longer. Perhaps the table that's taking
> > 15min has a ton of extra dead tuples left over from the fsm settings being too
> > low and/or vacuum being too infrequent.
>
> Does VACUUM FULL just lock entire tables and thus cause you to
> essentially have downtime on that database because it doesn't respond
> quickly or do you actually have to shut down postgres to safely do a
> vacuum full?

The former. You don't shut the database server down, but it won't be
responsive while vacuum full is running.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com