Re: Premature view materialization in 8.2?

Поиск
Список
Период
Сортировка
От Jonathan Ellis
Тема Re: Premature view materialization in 8.2?
Дата
Msg-id e06563880704061326q7872d8a8q3ab44e6971f80746@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Premature view materialization in 8.2?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On 4/6/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > The problem seems to be that clan_members_v contains a call to an
> > expensive function:
>
> I'll bet that the function is marked VOLATILE.  8.2 is more conservative
> about optimizing away volatile functions than previous releases.  If
> it has no side effects, mark it STABLE (or can it even be IMMUTABLE?).

That's exactly right, it should have been STABLE.

Thanks a lot for figuring that out for me!

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: SCSI vs SATA
Следующее
От: "Alex Deucher"
Дата:
Сообщение: postgres 8.2 seems to prefer Seq Scan