Re: Simple select hangs while CPU close to 100%

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Simple select hangs while CPU close to 100%
Дата
Msg-id 162867790707251042h432f46f8x61e22c70a5f35662@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Simple select hangs while CPU close to 100%  ("Jozsef Szalay" <jszalay@storediq.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jozsef Szalay"
Дата:
Сообщение: Re: Simple select hangs while CPU close to 100%
Следующее
От: "Jozsef Szalay"
Дата:
Сообщение: Re: Simple select hangs while CPU close to 100%