Thomas Markus wrote: > thanks for your awnsers > > i cant repeat the problem after increasing autovacuum_naptime to 5min. a > vacuumdb -f -a runs over night (and finished :) ) and now that blocking > statement finished after some seconds. it seems autovacuum = on is not > enough.
Enough for what? You still haven't said what the problem was. I am unsure if I should be concerned. It now sounds like ordinary slowness caused by table bloat. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
