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.