Re: Hash Join performance

Список
Период
Сортировка
От Tom Lane
Тема Re: Hash Join performance
Дата
Msg-id 22599.1236985691@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Hash Join performance  (Vamsidhar Thummala)
Ответы Re: Hash Join performance  (Vamsidhar Thummala)
Список pgsql-performance
Дерево обсуждения
Hash Join performance  (Vamsidhar Thummala, )
 Re: Hash Join performance  (Tom Lane, )
  Re: Hash Join performance  (Vamsidhar Thummala, )
   Re: Hash Join performance  (Tom Lane, )
    Re: Hash Join performance  (Vamsidhar Thummala, )
Vamsidhar Thummala <> writes:
> I am wondering why are we subtracting the entire Seq Scan time of Lineitem
> from the total time to calculate the HashJoin time.

Well, if you're trying to identify the speed of the join itself and not
how long it takes to provide the input for it, that seems like a
sensible calculation to make.

> Here is another plan I have for the same TPC-H 18 query with different
> configuration parameters (shared_buffers set to 400MB, just for experimental
> purposes) and HashJoin seems to take longer time (at least 155.58s based on
> above calculation):

Yeah, that seems to work out to about 25us per row instead of 3us, which
is a lot slower.  Maybe the hash got split up into multiple batches ...
what have you got work_mem set to?  Try turning on log_temp_files and
see if it records any temp files as getting created.

            regards, tom lane

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

Предыдущее
От: david@lang.hm
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4