PDA

View Full Version : Manual Vacuum after purging large amount of hands.



LeRoy
09-27-2011, 03:27 AM
After purging 6 million hands in my database I started manual vacuum.

It ran whole night but still is not finished (and seems like stopped as there are no new messages in log wondow).


Before the purge it took about an hour+ to vaccuum the same database...


Any thoughts? Cheers

LeRoy
09-27-2011, 06:12 AM
It's seems like working, though very slow.

Have to wait to see what will happen.

LeRoy
09-27-2011, 06:20 AM
Holy Cow, while I was thinking how long I have to wait till the end it finished.

It took about 13 hours to complete!

here is summary:
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.NOTICE: number of page slots needed (330736) exceeds max_fsm_pages (204800)

HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 330736.

What about this hint - should I really consider to change this parameter?

Elapsed time: 47161023 ms.

Sarek
09-27-2011, 12:19 PM
If they suggest... and you have plans to continue using this large DB - do it