Re: automatically refresh all materialized views?

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: automatically refresh all materialized views?
Дата
Msg-id CAHyXU0wkXMCrSPpFOZYeqsDEPNdq_tD5MdHay7vKYP+Br9Egkg@mail.gmail.com
обсуждение исходный текст
Ответ на automatically refresh all materialized views?  (Reece Hart <reece@harts.net>)
Ответы Re: automatically refresh all materialized views?  (Reece Hart <reece@harts.net>)
Список pgsql-general
On Fri, Feb 14, 2014 at 11:26 AM, Reece Hart <reece@harts.net> wrote:
> Is there a way to automatically refresh all materialized views, preferably
> in order of dependendency?
>
> I should be able to chase pg_depends entries to create this ordering, right?

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.

merlin


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

Предыдущее
От: Reece Hart
Дата:
Сообщение: automatically refresh all materialized views?
Следующее
От: lup
Дата:
Сообщение: Re: Is it reasonable to store double[] arrays of 30K elements