Re: After how many updates should a vacuum be performed?

The FSM seems to be large enough.  The verbose indicated
   39 relations, 5090 pages, and 3952 total pages needed.
Allocated FSM size is 1000 relations & 20000 pages = 186KB shared memory.

Also, the vacuum of all the database only took 1 hour and 20 minutes so
is there anything I should look at the next time this happens besides i/o?

Thanks.

Ellen


Tom Lane wrote:

> Ellen Cyran <ellen@urban.csuohio.edu> writes:
>
>>>Hm, that should be OK.  What do you have maintenance_work_mem set to?
>
>
>>It's set at the default 16384.
>
>
> That should be plenty for getting rid of a million or so tuples.  I'm
> wondering if you are seeing some weird locking effect.  Is the VACUUM
> constantly busy with I/O or does it sit and wait at points?  Do you have
> other queries actively accessing the table during the VACUUM?
>
>             regards, tom lane