| From: | Ian Westmacott <ianw(at)intellivid(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Why hash join instead of nested loop? |
| Date: | 2005-08-09 14:43:33 |
| Message-ID: | 1123598613.15206.17.camel@spectre.intellivid.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Yes, sorry, two totally different machines. The 7.4.8
run was on a dual P4 3.2GHz, and the 7.4.2 run was on
a dual hyperthreaded Xeon 2.4GHz.
--Ian
On Tue, 2005-08-09 at 10:33, Tom Lane wrote:
> Ian Westmacott <ianw(at)intellivid(dot)com> writes:
> > On Mon, 2005-08-08 at 20:58, Tom Lane wrote:
> >> I'd be interested to see results from other people using 7.4.* too.
>
> > 7.4.8:
> > Total runtime: 0.198 ms
>
> > 7.4.2:
> > Total runtime: 0.697 ms
>
> Just to be clear: those are two different machines of different speeds,
> right? I don't believe we put any factor-of-three speedups into 7.4.*
> after release ;-)
>
> regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rhett Garber | 2005-08-09 16:51:51 | Re: Why hash join instead of nested loop? |
| Previous Message | Tom Lane | 2005-08-09 14:33:37 | Re: Why hash join instead of nested loop? |