Re: Implementing Incremental View Maintenance

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Implementing Incremental View Maintenance
Date: 2020-02-13 19:57:11
Message-ID: 1581623831203-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Yugo Nagata wrote
> Thank you for your suggestion! I agree that the feature to switch between
> normal materialized view and incrementally maintainable view is useful.
> We will add this to our ToDo list. Regarding its syntax,
> I would not like to add new keyword like NONINCREMENTAL, so how about
> the following
>
> ALTER MATERIALIZED VIEW ... SET {WITH | WITHOUT} INCREMENTAL REFRESH
>
> although this is just a idea and we will need discussion on it.

Thanks I will follow that discussion on GitHub
https://github.com/sraoss/pgsql-ivm/issues/79

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-02-13 20:56:33 Retiring pg_regress' --load-language option
Previous Message Andres Freund 2020-02-13 18:47:10 Re: In PG12, query with float calculations is slower than PG11