Re: Why hash join instead of nested loop?

Поиск
Список
Период
Сортировка
От Ian Westmacott
Тема Re: Why hash join instead of nested loop?
Дата
Msg-id 1123598613.15206.17.camel@spectre.intellivid.com
обсуждение исходный текст
Ответ на Re: Why hash join instead of nested loop?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@intellivid.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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why hash join instead of nested loop?
Следующее
От: Rhett Garber
Дата:
Сообщение: Re: Why hash join instead of nested loop?