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

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: high user cpu, massive SELECTs, no io waiting problem
Дата
Msg-id 4D5B7DC2.6030807@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: high user cpu, massive SELECTs, no io waiting problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: high user cpu, massive SELECTs, no io waiting problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
Kevin Grittner wrote:
> Could you show your postgresql.conf file, with all comments removed


I just added a sample query to provide the data we always want here
without people having to edit their config files, by querying
pg_settings for it, to http://wiki.postgresql.org/wiki/Server_Configuration

I already updated http://wiki.postgresql.org/wiki/SlowQueryQuestions and
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems to mention
this too.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books


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

Предыдущее
От: "Kim A. Brandt"
Дата:
Сообщение: Re: LIMIT on partitioned-table!?
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: high user cpu, massive SELECTs, no io waiting problem