Re: automatically refresh all materialized views? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: automatically refresh all materialized views?
Date
Msg-id CAHyXU0wkXMCrSPpFOZYeqsDEPNdq_tD5MdHay7vKYP+Br9Egkg@mail.gmail.com
Whole thread Raw
In response to automatically refresh all materialized views?  (Reece Hart <reece@harts.net>)
Responses Re: automatically refresh all materialized views?  (Reece Hart <reece@harts.net>)
List 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 by date:

Previous
From: Reece Hart
Date:
Subject: automatically refresh all materialized views?
Next
From: lup
Date:
Subject: Re: Is it reasonable to store double[] arrays of 30K elements