Re: Premature view materialization in 8.2?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Premature view materialization in 8.2?
Дата
Msg-id
15399.1175882434@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Premature view materialization in 8.2? "Jonathan Ellis" <jonathan@utahpython.org>
Re: Premature view materialization in 8.2? Tom Lane <tgl@sss.pgh.pa.us>
Re: Premature view materialization in 8.2? "Jonathan Ellis" <jonathan@utahpython.org>
Re: Premature view materialization in 8.2? Tom Lane <tgl@sss.pgh.pa.us>
Re: Premature view materialization in 8.2? "Jonathan Ellis" <jonathan@utahpython.org>
Re: Premature view materialization in 8.2? Tom Lane <tgl@sss.pgh.pa.us>
Re: Premature view materialization in 8.2? "Jonathan Ellis" <jonathan@utahpython.org>
Re: Premature view materialization in 8.2? Tom Lane <tgl@sss.pgh.pa.us>
Re: Premature view materialization in 8.2? "Jonathan Ellis" <jonathan@utahpython.org>
Re: Premature view materialization in 8.2? Tom Lane <tgl@sss.pgh.pa.us>
Re: Premature view materialization in 8.2? "Jonathan Ellis" <jonathan@utahpython.org>
"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 по дате отправления
От: Jonathan Ellis
Дата:
От: Jonathan Ellis
Дата:
FAQ