Skip site navigation (1) Skip section navigation (2)

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

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-performance(at)postgresql(dot)org, Verteiler_A-Team <a-team(at)turtle-entertainment(dot)de>, bm(at)turtle-entertainment(dot)de, Felix Feinhals <ff(at)turtle-entertainment(dot)de>, tp(at)turtle-entertainment(dot)de
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Date: 2011-02-16 14:55:39
Message-ID: 4D5BE56B.4030307@2ndquadrant.com (view raw or flat)
Thread:
Lists: 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(at)2ndQuadrant(dot)com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books


In response to

Responses

pgsql-performance by date

Next:From: Justin PittsDate: 2011-02-16 15:04:42
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Previous:From: Kevin GrittnerDate: 2011-02-16 14:37:32
Subject: Re: high user cpu, massive SELECTs, no io waiting problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group