Re: Premature view materialization in 8.2?

Список
Период
Сортировка
От Tom Lane
Тема Re: Premature view materialization in 8.2?
Дата
Msg-id 15399.1175882434@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:
> I can do that...  you don't think the fact I mentioned, that
> redefining the view to leave out the expensive function fixes the
> problem, is relevant?

Hm, I'd not have thought that an expensive function would get evaluated
partway up the join tree, but maybe that's wrong.  You never did show
us the actual view definition ...

            regards, tom lane

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

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