Re: 8.1 vs 8.2.1 view optimization
От
Tom Lane
Тема
Re: 8.1 vs 8.2.1 view optimization
Дата
Msg-id
26458.1168983637@sss.pgh.pa.us
Ответ на
8.1 vs 8.2.1 view optimization (Nathan Bell)
Список
Дерево обсуждения
8.1 vs 8.2.1 view optimization Nathan Bell <nathanb@actarg.com>
Re: 8.1 vs 8.2.1 view optimization Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 vs 8.2.1 view optimization Nathan Bell <nathanb@actarg.com>
Re: 8.1 vs 8.2.1 view optimization Martijn van Oosterhout <kleptog@svana.org>
Re: 8.1 vs 8.2.1 view optimization Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 vs 8.2.1 view optimization Tom Lane <tgl@sss.pgh.pa.us>
Nathan Bell writes: > Firing up 8.2.1 I notice that sub-items in a view are optimized out if > they aren't being selected. You mean "not optimized out", I suppose. Declare your function as non-volatile if you want the optimizer to assume it's OK to discard. regards, tom lane
В списке pgsql-general по дате отправления
