Re: Materialized views

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: Materialized views
Дата
Msg-id C7E6FA42-D9F9-4DB0-BC9F-EA630B0ED5AF@kineticode.com
обсуждение исходный текст
Ответ на Materialized views  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
On Nov 8, 2011, at 4:23 PM, Josh Berkus wrote:

>> Well, there has to be some way to refresh an MV at regular intervals, no?
>
> For periodic update matviews, yes.  However, Kevin needs only produce
> the command/function call for updating a generic periodic matview.  He
> doesn't need to provide a scheduling utility.  For simple cases, cron works.

Oh, I see. I was assuming it would be automatic-ish, with the declaration of the matview including update interval
information.Could certainly come later, though. 

Best,

David



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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Measuring relation free space
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Materialized views