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

From Bruce Momjian
Subject Re: performance hit with --enable-debug
Date
Msg-id 200101141737.MAA29166@candle.pha.pa.us
Whole thread Raw
In response to Re: performance hit with --enable-debug  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: performance hit with --enable-debug
List pgsql-general
> Thomas T. Thai writes:
>
> > what kind of performance hit would i endure if i compiled with
> > --enable-debug on -current
>
> 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.
> Personally, I wouldn't worry about it too much, especially if you're
> running beta and want to track down potential bugs.

Not sure about the longer load times.  Once the postmaster is loaded and
the first postgres client, all the pages are probably faulted in at that
point.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: Re: performance hit with --enable-debug
Next
From: Bruce Momjian
Date:
Subject: Re: Re: performance hit with --enable-debug