| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2011-02-16 13:15:41 | Re: [PERFORM] pgbench to the MAXINT |
| Previous Message | Kim A. Brandt | 2011-02-16 07:24:06 | Re: LIMIT on partitioned-table!? |