| From: | Justin Pitts <justinpitts(at)gmail(dot)com> |
|---|---|
| To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, 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 15:04:42 |
| Message-ID: | AANLkTi=mYVFE7QYfrTskUMuJXO34wbzY=1SNi+qgbUhf@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I think adding
UNION ALL SELECT 'postgres version', version();
might be a good thing.
On Wed, Feb 16, 2011 at 9:55 AM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> 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
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-02-16 15:40:31 | Re: [PERFORM] pgbench to the MAXINT |
| Previous Message | Greg Smith | 2011-02-16 14:55:39 | Re: high user cpu, massive SELECTs, no io waiting problem |