Re: automatically refresh all materialized views?

Поиск
Список
Период
Сортировка
От Reece Hart
Тема Re: automatically refresh all materialized views?
Дата
Msg-id CAKNDN-c8UiRf8CHanJqYfGgwdJEGbO6jMqJFwMGWQteBGVeVkA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: automatically refresh all materialized views?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Feb 14, 2014 at 10:15 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
yeah -- you could do this with some gymnastics and some dynamic SQL.
If I were lazy (check), I would just encode the order in the name of
the view somehow.

Thanks. That's exactly what I do already. Apparently, I'm even lazier than you!

In case anyone out there is looking for a convention, here's one that I find useful:  _v for views intended for interactive queries, _dv (defining views) for views that are too slow to use interactively, and _mv for the materialized _dv views. 

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

Предыдущее
От: Samuel Gilbert
Дата:
Сообщение: Re: Issues with patitionning and triggers
Следующее
От: "Antman, Jason (CMG-Atlanta)"
Дата:
Сообщение: Re: File system level backup of shut down standby does not work?