Re: performance hit with --enable-debug - Mailing list pgsql-general

From Tom Lane
Subject Re: performance hit with --enable-debug
Date
Msg-id 26527.979495096@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance hit with --enable-debug  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: performance hit with --enable-debug  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: performance hit with --enable-debug  (Patrick Welche <prlw1@newn.cam.ac.uk>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: performance hit with --enable-debug
Next
From: Bruce Momjian
Date:
Subject: Re: performance hit with --enable-debug