From:
Merlin Moncure <mmoncure(at)gmail(dot)com>
To:
"David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc:
Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, 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 17:47:56
Message-ID:
h2pb42b73151004061047u38f69a7dp680d9e40a0e1a19a@mail.gmail.com (view raw or flat )
Thread:
2010-04-06 05:47:02 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-04-06 09:32:37 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-04-06 16:08:44 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 17:47:56 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-04-06 17:52:25 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 18:06:42 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 13:07:06 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-04-06 16:09:07 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 14:28:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-06 17:00:30 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 17:17:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-06 18:04:15 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 18:15:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-06 18:39:32 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 19:50:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-06 19:53:33 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-04-06 20:10:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-04-06 19:55:03 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-04-06 19:58:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-06 20:13:22 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-04-06 21:40:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-07 03:33:14 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-04-07 06:02:40 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-04-06 18:28:38 from Greg Smith <greg(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
On Tue, Apr 6, 2010 at 12:08 PM, David E. Wheeler <david(at)kineticode(dot)com> wrote:
> On Apr 6, 2010, at 2:32 AM, Takahiro Itagaki wrote:
>
>>> In our test, which does 5801 of these pings during the test, they take
>>> an average of 15x longer to execute on 9.0 as 8.4 ( 0.77ms vs. 0.05ms ).
>>>
>>> Any clue why this would be?
>>
>> Did you use the same configure options between them?
>
> Yes.
>
>> For example, --enable-debug or --enable-cassert.
hmm. ssl? (I don't see any interesting difference in time either
btw). can you log in w/psql and confirm the difference there w/timing
switch?
merlin
In response to
pgsql-hackers by date
Next :From: David E. WheelerDate: 2010-04-06 17:52:25Subject : Re: SELECT constant; takes 15x longer on 9.0?Previous :From : Magnus HaganderDate : 2010-04-06 17:39:56Subject : Re: BUG #5394: invalid declspec for PG_MODULE_MAGIC
