Re: Why hash join instead of nested loop?

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

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