From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Greg Smith <greg@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Cc: Verteiler_A-Team <a-team@turtle-entertainment.de>
Cc: bm@turtle-entertainment.de
Cc: Felix Feinhals <ff@turtle-entertainment.de>
Cc: tp@turtle-entertainment.de
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Date: Wed, 16 Feb 2011 08:37:32 -0600
Message-ID: <4D5B8CCC020000250003AAFD@gw.wicourts.gov> (raw)
In-Reply-To: <4D5B7DC2.6030807@2ndquadrant.com>
References: <F1CD4AC5B4A5024AAB60E28A82A8450A03CEB0C7@winexch1.office.turtle-entertainment.de>
<4D5A6C60020000250003AA98@gw.wicourts.gov>
<4D5B7DC2.6030807@2ndquadrant.com>
Greg Smith <greg@2ndquadrant.com> wrote:
> 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
Nice! Thanks!
A few very nice things about this:
(1) You don't need rights to the postgresql.conf file; any user can
run this.
(2) You don't need to know how to strip the comments with sed or
perl or something, or go through the file with tedious manual
editing.
(3) It shows some things which aren't coming from the
postgresql.conf file which might be of interest.
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.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, greg@2ndquadrant.com, a-team@turtle-entertainment.de, bm@turtle-entertainment.de, ff@turtle-entertainment.de, tp@turtle-entertainment.de
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
In-Reply-To: <4D5B8CCC020000250003AAFD@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox