Re: Adjusting debug_print_plan to be more useful by default - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Adjusting debug_print_plan to be more useful by default
Date
Msg-id 18007.1219198884@sss.pgh.pa.us
Whole thread Raw
In response to Re: Adjusting debug_print_plan to be more useful by default  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Robert Treat <xzilla@users.sourceforge.net> writes:
> On Tuesday 19 August 2008 12:40:11 Tom Lane wrote:
>> I'd also like to propose making debug_pretty_print default to ON.
>> At least for me, the other formatting is 100% unreadable.

> Any thoughts on just making it always print that way and getting rid of the 
> GUC? Anyone want to argue they'll be turning this off? 

Hmm ... I don't personally have any use for the OFF setting, but if
there's someone out there who actually wants to run with the
debug_print_xxx settings enabled for any length of time, I can see where
there'd be a log-volume problem with the pretty-printed format.  Such a
person would presumably also want to do automated analysis of the
results and so wouldn't give a fig for nice whitespace anyhow.

Maybe that's a long shot, but the other side of the coin is that taking
it out isn't going to save us a thing except one GUC variable ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Adjusting debug_print_plan to be more useful by default
Next
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF