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

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: high user cpu, massive SELECTs, no io waiting problem
Дата
Msg-id 4D5BE56B.4030307@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  (Justin Pitts <justinpitts@gmail.com>)
Список pgsql-performance
Kevin Grittner wrote:
> In fact, I wonder whether we shouldn't leave a couple items you've
> excluded, since they are sometimes germane to problems posted, like
> lc_collate and TimeZone.

I pulled some of them out only because they're not really
postgresql.conf settings; lc_collate and lc_ctype for example are set at
initdb time.  Feel free to hack on that example if you feel it could be
improved, just be aware which of those things are not really in the main
config file when pondering if they should be included.

--
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 по дате отправления:

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