Re: performance hit with --enable-debug
От
Patrick Welche
Тема
Re: performance hit with --enable-debug
Дата
Msg-id
20010115183740.C1236@quartz.newn.cam.ac.uk
Ответ на
Re: performance hit with --enable-debug (Tom Lane)
Список
Дерево обсуждения
performance hit with --enable-debug "Thomas T. Thai" <tom@minnesota.com>
Re: performance hit with --enable-debug Peter Eisentraut <peter_e@gmx.net>
Re: performance hit with --enable-debug Bruce Momjian <pgman@candle.pha.pa.us>
Re: performance hit with --enable-debug Tom Lane <tgl@sss.pgh.pa.us>
Re: performance hit with --enable-debug Bruce Momjian <pgman@candle.pha.pa.us>
Re: performance hit with --enable-debug Peter Eisentraut <peter_e@gmx.net>
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>
Re: performance hit with --enable-debug "Thomas T. Thai" <tom@minnesota.com>
Re: Re: performance hit with --enable-debug Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: performance hit with --enable-debug Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: performance hit with --enable-debug Peter Eisentraut <peter_e@gmx.net>
Re: Re: performance hit with --enable-debug Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: performance hit with --enable-debug "Thomas T. Thai" <tom@minnesota.com>
Re: performance hit with --enable-debug Tom Lane <tgl@sss.pgh.pa.us>
On Sun, Jan 14, 2001 at 12:58:16PM -0500, Tom Lane wrote: > Bruce Momjian 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 по дате отправления