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, Thomas Pöhler <tp(at)turtle-entertainment(dot)de>, Verteiler_A-Team <a-team(at)turtle-entertainment(dot)de>, bm(at)turtle-entertainment(dot)de, Felix Feinhals <ff(at)turtle-entertainment(dot)de>
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Date: 2011-02-16 07:33:22
Message-ID: 4D5B7DC2.6030807@2ndquadrant.com (view raw or flat)
Thread:
Lists: 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(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: Greg SmithDate: 2011-02-16 13:15:41
Subject: Re: [PERFORM] pgbench to the MAXINT
Previous:From: Kim A. BrandtDate: 2011-02-16 07:24:06
Subject: Re: LIMIT on partitioned-table!?

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