From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Mike Mascari <mascarm(at)mascari(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Weird function behavior from Sept 11 snapshot |
Date: | 2000-09-12 16:39:04 |
Message-ID: | 14096.968776744@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> Another followup: on 7.0.2, with different optimizations etc,
> sum(float8) takes 1.95 seconds, rather than the 5.2 on the current tree.
> I'd better look at the compilation optimizations; is there another
> explanation for the factor of 2.6 difference (!!)?
If you are running with --enable-cassert then there is a whole bunch
of memory-stomp debugging overhead turned on in current sources,
including such time-consuming stuff as clearing every pfree'd block.
7.0.*'s --enable-cassert is not nearly as expensive.
I plan to make that stuff not-default when we go beta, but right now
it seems like a good idea to have it on for testing...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Weilguni | 2000-09-12 16:39:54 | Re: Patch for TNS services |
Previous Message | Bruce Momjian | 2000-09-12 16:31:44 | Re: Status of new relation file naming |