Re: Premature view materialization in 8.2?

Список
Период
Сортировка
От Tom Lane
Тема Re: Premature view materialization in 8.2?
Дата
Msg-id 15092.1175881227@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Premature view materialization in 8.2?  ("Jonathan Ellis")
Ответы Re: Premature view materialization in 8.2?  ("Jonathan Ellis")
Список pgsql-performance
Дерево обсуждения
Premature view materialization in 8.2?  ("Jonathan Ellis", )
 Re: Premature view materialization in 8.2?  (Tom Lane, )
  Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
   Re: Premature view materialization in 8.2?  (Tom Lane, )
    Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
     Re: Premature view materialization in 8.2?  (Tom Lane, )
      Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
       Re: Premature view materialization in 8.2?  (Tom Lane, )
        Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
         Re: Premature view materialization in 8.2?  (Tom Lane, )
          Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
"Jonathan Ellis" <> writes:
> On 4/6/07, Tom Lane <> wrote:
>> Yeah, it sure is the same plan, and 8.2 seems to be a tad faster right
>> up to the hash join on user_id.  Is user_id a textual datatype?

> user_id is an int; they are both C locale.

Really!?  So much for that theory.

Is work_mem set similarly on both installations?

The only other thing I can think is that you've exposed some unfortunate
corner case in the hash join logic.  Would you be willing to send me
(off-list) the lists of user_ids being joined?  That would be the
clan_members.user_id column and the user_id column from the join of
parties and clan_participants.

            regards, tom lane

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: SCSI vs SATA
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: SCSI vs SATA