Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> The effect in terms of query execution speed is probably minimal. The
>> problem is that the executables get about 15% larger, which can lead to
>> longer load times, more memory usage, and ultimately to some speed issues.
> Not sure about the longer load times.
I don't believe that either. The debug symbol tables aren't part of the
memory-resident image, they just sit out there on disk ... at least in
Unixen that I'm familiar with.
I think this is worth looking at more closely. I can't see any reason
that Tom should be seeing a 30x performance hit from --enable-debug;
there's something going on here that I don't understand.
regards, tom lane