Justin Pitts <justinpitts@xxxxxxxxx> wrote: > I think adding > > UNION ALL SELECT 'postgres version', version(); > > might be a good thing. Good point. Added. > Greg Smith <greg@xxxxxxxxxxxxxxx> 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.... :-) -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
