Re: high user cpu, massive SELECTs, no io waiting problem

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: high user cpu, massive SELECTs, no io waiting problem
Дата
Msg-id 4D5A6C60020000250003AA98@gw.wicourts.gov
обсуждение исходный текст
Ответ на high user cpu, massive SELECTs, no io waiting problem  (Thomas Pöhler <tp@turtle-entertainment.de>)
Ответы Re: high user cpu, massive SELECTs, no io waiting problem  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-performance
Дерево обсуждения 
Thomas Pöhler<tp@turtle-entertainment.de> wrote:

> we have lots of SELECTs running.

How many?

Could you show your postgresql.conf file, with all comments removed?

What does vmstat 1 (or similar) show at baseline and during your
problem episodes?

-Kevin

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: high user cpu, massive SELECTs, no io waiting problem
Следующее
От: Mark Mikulec
Дата:
Сообщение: pg_dumpall affecting performance