Materialized View Incremental Refresh right join

Поиск
Список
Период
Сортировка
От hariprasath nallasamy
Тема Materialized View Incremental Refresh right join
Дата
Msg-id CAGgejVyA2OHeU8XG=1n+DZj+oJmNChGN69BexdHP_Ymq+QBiVA@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Дерево обсуждения
Hi all
      Using logical decoding i set up a plugin to refresh materialized views incrementally(only the changes that are did after the previous refresh). I used the approach that oracle uses for fast refresh of materialized view using log table to record delta changes.

     Mostly i covered for single table and for join(left and right) its an ideal solution but whenever a right join comes to play a role, its hard to get these delta change. Any insights so that i get to proceed further..?

P.S: For left join Foreign key constraint is followed
Example the view joining 3 tables as [T1 left join T2 left join T3]
Foreign key constraints are imposed so that, a key in T1 is deleted only after the same keys in T2 and T3 are deleted


Happy weekend
-harry

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Re: PROPOSAL: make PostgreSQL sanitizers-friendly (and prevent information disclosure)
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [PATCH] Transaction traceability - txid_status(bigint)