Justin Pitts <justinpitts(at)gmail(dot)com> wrote:
> I think adding
> UNION ALL SELECT 'postgres version', version();
> might be a good thing.
Good point. Added.
> 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.
Basically, the ones I could remember us needing to ask about on
multiple occasions, I put back -- provisionally. If someone thinks
they're pointless, I won't worry about them being dropped again:
time zone, character encoding scheme, character set, and collation.
I'm pretty sure I've seen us ask about all of those in trying to
sort out a problem.
I also tried the query on a newly installed HEAD build which had no
manual changes to the postgresql.conf file and found a few others
which seemed to me to be worth suppressing.
I took my shot -- anyone else is welcome to do so.... :-)
In response to
pgsql-performance by date
|Next:||From: Ross J. Reedstrom||Date: 2011-02-16 16:28:32|
|Subject: Re: Really really slow select count(*)|
|Previous:||From: Scott Marlowe||Date: 2011-02-16 16:02:43|
|Subject: Re: high user cpu, massive SELECTs, no io waiting problem|