| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SELECT constant; takes 15x longer on 9.0? |
| Date: | 2010-04-06 18:39:32 |
| Message-ID: | 157174C9-CA95-474A-B263-D26D74FD0C4C@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Apr 6, 2010, at 11:15 AM, Tom Lane wrote:
>> By stupidly having configured with --enable-cassert --enable-debug without realizing it. I've just rebuilt without them and run the tests again using the default postgresql.conf and I'm back down to 57s and 46s over two runs.
>
> Huh. I'm still curious, because in my test the overhead of those
> options seemed to be about 3x. So there's still something considerably
> different between what you did and what I did.
Are you doing this on a Mac?
> Are you testing a separate connection per ping query? I think I
> neglected to compare that case with and without assert overhead.
No, should be one connection for the entire test suite.
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-04-06 18:58:31 | Re: Remaining Streaming Replication Open Items |
| Previous Message | Greg Smith | 2010-04-06 18:28:38 | Re: SELECT constant; takes 15x longer on 9.0? |