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: (view raw or whole 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

I already updated and to mention 
this too.

Greg Smith   2ndQuadrant US    greg(at)2ndQuadrant(dot)com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support
"PostgreSQL 9.0 High Performance":

In response to


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-2015 The PostgreSQL Global Development Group