Re: [HACKERS] profile-guided opt. w/ GCC

2004-09-30 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Neil Conway wrote: >> The patch adds a new make target ("profile-opt") that does the PGO >> steps outlined above -- the "representative input data" is the >> regression tests running in serial mode. I haven't run any benchmarks >> yet (if someone wants

Re: [HACKERS] profile-guided opt. w/ GCC

2004-09-30 Thread Jeroen T. Vermeulen
On Thu, Sep 30, 2004 at 07:07:27PM +1000, Neil Conway wrote: > I think it would be cool to add support for PGO to PostgreSQL's build > system (for 8.1). There are a lot of situations where PostgreSQL is > compiled once, and then used for weeks or months (compilations for > inclusion in a distro b

Re: [HACKERS] profile-guided opt. w/ GCC

2004-09-30 Thread Neil Conway
On Thu, 2004-09-30 at 19:49, Peter Eisentraut wrote: > I doubt that the regression tests are anywhere near representative input > data. They run a proportion of borderline and error cases that is much > higher than I would expect in normal use. That's definitely true. At first glance, the regre

Re: [HACKERS] profile-guided opt. w/ GCC

2004-09-30 Thread Peter Eisentraut
Neil Conway wrote: > The patch adds a new make target ("profile-opt") that does the PGO > steps outlined above -- the "representative input data" is the > regression tests running in serial mode. I haven't run any benchmarks > yet (if someone wants to try that, I'd be very curious to see the > resu

[HACKERS] profile-guided opt. w/ GCC

2004-09-30 Thread Neil Conway
Profile-guided optimization is a relatively new GCC feature that improves the quality of generated code by: - compiling a copy of the source program with some profiling hooks - running this copy of the program on some representative input data - recompiling the program using the profiling data pro