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)
Ответы: Re: Why hash join instead of nested loop?  (Ian Westmacott)
Список: pgsql-performance

Скрыть дерево обсуждения

Why hash join instead of nested loop?  (Rhett Garber, )
 Re: Why hash join instead of nested loop?  (Havasvölgyi Ottó, )
  Re: Why hash join instead of nested loop?  (Rhett Garber, )
   Re: Why hash join instead of nested loop?  (Tom Lane, )
    Re: Why hash join instead of nested loop?  (Rhett Garber, )
     Re: Why hash join instead of nested loop?  (Tom Lane, )
      Re: Why hash join instead of nested loop?  ("Steinar H. Gunderson", )
      Re: Why hash join instead of nested loop?  (Michael Fuhr, )
      Re: Why hash join instead of nested loop?  (Ian Westmacott, )
       Re: Why hash join instead of nested loop?  (Tom Lane, )
        Re: Why hash join instead of nested loop?  (Ian Westmacott, )
      Re: Why hash join instead of nested loop?  (Rhett Garber, )
       Re: Why hash join instead of nested loop?  (Tom Lane, )
        Re: Why hash join instead of nested loop?  (Rhett Garber, )
         Re: Why hash join instead of nested loop?  (Tom Lane, )
          Re: Why hash join instead of nested loop?  (Rhett Garber, )
           Re: Why hash join instead of nested loop?  (Tom Lane, )
            Re: Why hash join instead of nested loop?  (Rhett Garber, )

Ian Westmacott <> 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: Table locking problems?
От: Dan Harris
Дата:
Сообщение: Re: Table locking problems?