Re: [GENERAL] Incremental refresh - Materialized view

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема Re: [GENERAL] Incremental refresh - Materialized view
Дата
Msg-id BN6PR22MB0145E937CCEDC7B320DF82C38C510@BN6PR22MB0145.namprd22.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Incremental refresh - Materialized view  (Krithika Venkatesh <krithikavenkatesh31@gmail.com>)
Ответы Re: [GENERAL] Incremental refresh - Materialized view  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения
You have already been informed. PG, as yet, does not allow incremental refresh of a MV.  It allows online refresh of a MV, but that it does by doing a full table scan of the base table and rebuilding the MV.


From: Krithika Venkatesh <krithikavenkatesh31@gmail.com>
To: John R Pierce <pierce@hogranch.com>
Cc: pgsql-general@postgresql.org
Sent: Tuesday, November 7, 2017 2:35 AM
Subject: Re: [GENERAL] Incremental refresh - Materialized view

Materialized view log is one of the feature in oracle. It creates a log in which the changes made to the table are recorded. This log is required for an asynchronous materialized view that is refreshed incrementally.

I read in the below link about incrementally refreshing the materialized view in postgresql:


Can someone let me how to do incremental refresh using Write Ahead Log

Thanks,
Krithika





On 07-Nov-2017 12:37 PM, "John R Pierce" <pierce@hogranch.com> wrote:
On 11/6/2017 10:38 PM, Krithika Venkatesh wrote:
I need to implement incremental refresh of materialized view.

Please let me know how to do the incremental refresh of materialized view in postgresql 9.5.9 version.

Is there anything similar to materialized view log in postgresql.


you refresh a materialized view with REFRESH MATERIALIZED VIEW name;    There's no 'incremental' methods, as views can be quite complex.

I do not know what you mean by 'materialized view log', is this a feature of some other database server ?



--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail pref/pgsql-general



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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: [GENERAL] Incremental refresh - Materialized view
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: [GENERAL] idle in transaction, why