On Thu, 09 Dec 2021 16:06:27 +
"Phil Endecott" wrote:
> Thanks both for your replies.
>
> Wicher wrote:
> > On Mon, 06 Dec 2021 18:48:47 +
> > "Phil Endecott" wrote:
> >> and
> >> I need to modify the definition of a view that filters the "new"
> >> values from the raw table each ti
On Mon, 06 Dec 2021 18:48:47 +
"Phil Endecott" wrote:
> and
> I need to modify the definition of a view that filters the "new"
> values from the raw table each time the materialised view is
> refreshed.
You won't necessarily need to rewrite the "recent data" view definitions, I
think. Wh
On Mon, 6 Dec 2021 at 18:48, Phil Endecott
wrote:
>
> - I have a raw data table, indexed on a timestamp column, to which
> new data is regularly being added.
>
> - I have a set of views that produce hourly/daily/monthly summaries
> of this data. Querying these views is slow, so I'd like to mak
