| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
| 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:15:14 |
| Message-ID: | 24362.1270577714@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> On Apr 6, 2010, at 10:17 AM, Tom Lane wrote:
>> So I'm not sure where your 15x is coming from, but I don't see it.
> 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 testing a separate connection per ping query? I think I
neglected to compare that case with and without assert overhead.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-04-06 18:20:37 | Re: Proposal: Add JSON support |
| Previous Message | Robert Haas | 2010-04-06 18:10:32 | Re: Proposal: Add JSON support |