Postgres Pro
Downloads
Home   >   mailing lists

Re: high user cpu, massive SELECTs, no io waiting problem - Mailing list pgsql-performance

From Greg Smith
Subject Re: high user cpu, massive SELECTs, no io waiting problem
Date
Msg-id 4D5BE56B.4030307@2ndquadrant.com
Whole thread Raw
In response to Re: high user cpu, massive SELECTs, no io waiting problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: high user cpu, massive SELECTs, no io waiting problem  (Justin Pitts <justinpitts@gmail.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Next
From: Scott Marlowe
Date:
Subject: Re: high user cpu, massive SELECTs, no io waiting problem