Re: Simple select hangs while CPU close to 100% - Mailing list pgsql-performance

2007/7/25, Jozsef Szalay <jszalay@storediq.com>:
> Hi Pavel,
>
>
> Yes I did vacuum. In fact the only way to "fix" this problem is
> executing a "full" vacuum. The plain vacuum did not help.
>
>
> Regards,
> Jozsef

It's question if vacuum was done.

Try vacuum verbose;

Maybe your max_fsm_pages is too low and you have to up it.

Regards
Pavel Stehule