From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: massive speedup on temp table creation/destruction? |
Date: | 2006-09-01 04:21:37 |
Message-ID: | 28391.1157084497@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Merlin Moncure" <mmoncure(at)gmail(dot)com> writes:
> On 8/31/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> What I found surprising is that I get numbers like 430 tps from HEAD
>> and 220 tps from REL8_1_STABLE. This test case is of course not about
>> performance, but I'm not quite sure what we changed that would produce
>> a 2X speedup from 8.1. Can anyone else replicate this?
> I did not confirm your results unfortunately. this is on quad opteron,
I was trying it on a dual Xeon EM64T with hyperthreading on ... I wonder
if we've unintentionally done something that optimizes for that platform?
I don't make any claim that this test case is interesting in itself,
but it might be telling us something about more-mainstream cases.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-09-01 04:23:37 | Re: Roadmaps 'n all that |
Previous Message | Steve Atkins | 2006-09-01 04:10:13 | Re: Roadmaps 'n all that |