Re: automatically refresh all materialized views?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Reece Hart <reece(at)harts(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: automatically refresh all materialized views?
Date: 2014-02-14 18:15:03
Message-ID: CAHyXU0wkXMCrSPpFOZYeqsDEPNdq_tD5MdHay7vKYP+Br9Egkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 14, 2014 at 11:26 AM, Reece Hart <reece(at)harts(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message lup 2014-02-14 22:07:43 Re: Is it reasonable to store double[] arrays of 30K elements
Previous Message Reece Hart 2014-02-14 17:26:45 automatically refresh all materialized views?