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

From Patrick Welche
Subject Re: performance hit with --enable-debug
Date
Msg-id 20010115183740.C1236@quartz.newn.cam.ac.uk
Whole thread Raw
In response to Re: performance hit with --enable-debug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sun, Jan 14, 2001 at 12:58:16PM -0500, Tom Lane wrote:
> 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.

I suppose something to try is compile with --enable-debug, then strip the
resultant executable, and see if it is as fast as (should be identical to?)
executable generated without --enable-debug..

Cheers,

Patrick

pgsql-general by date:

Previous
From: Richard Seymour
Date:
Subject: simple version question
Next
From: snef
Date:
Subject: date/time