On Wed, 20 Nov 2002, Francisco Reyes wrote:
> On Wed, 20 Nov 2002, Medi Montaseri wrote:
>
> > In 7.2, you can run the vacuum in parallel with other database activities...
>
> As far as I know this is not the case for "vacuum full".
The thing that blocks vacuum full are pending transactions. If the
connections aren't holding open a transaction the vacuum full will run
just fine.
For most folks, daily / hourly vacuums (not full vacuums) in 7.2 are
all you need, with a weekly or so vacuum full.