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.
