View optimization

Поиск
Список
Период
Сортировка
От Richard Ollier
Тема View optimization
Дата
Msg-id 45876B4A.5040901@tequila.co.jp
обсуждение исходный текст
Ответы Re: View optimization
Список pgsql-general
Hello,

I was wondering it there was a way to optimize a view.
If my view contains 20 LEFT joins, my guessing is that each time I will
make a select on it, the view will be completely recalculated. Is there
a way to have it up and running all the time like a table would be ?

Any advice here is more than welcome !

Thanks
Richard

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