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@xxxxxxxxxxxxxxxxx> 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
