| From: | "r(dot)takahashi_2(at)fujitsu(dot)com" <r(dot)takahashi_2(at)fujitsu(dot)com> |
|---|---|
| To: | 'Yugo NAGATA' <nagata(at)sraoss(dot)co(dot)jp> |
| Cc: | 'Zhihong Yu' <zyu(at)yugabyte(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Subject: | RE: Implementing Incremental View Maintenance |
| Date: | 2021-08-05 08:53:47 |
| Message-ID: | OS0PR01MB5682A90859F1B7772460A74082F29@OS0PR01MB5682.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Nagata-san,
Thank you for your reply.
> I'll investigate this more, but we may have to prohibit views on partitioned
> table and partitions.
I think this restriction is strict.
This feature is useful when the base table is large and partitioning is also useful in such case.
I have several additional comments on the patch.
(1)
The following features are added to transition table.
- Prolong lifespan of transition table
- If table has row security policies, set them to the transition table
- Calculate pre-state of the table
Are these features only for IVM?
If there are other useful case, they should be separated from IVM patch and
should be independent patch for transition table.
(2)
DEPENDENCY_IMMV (m) is added to deptype of pg_depend.
What is the difference compared with existing deptype such as DEPENDENCY_INTERNAL (i)?
(3)
Converting from normal materialized view to IVM or from IVM to normal materialized view is not implemented yet.
Is it difficult?
I think create/drop triggers and __ivm_ columns can achieve this feature.
Regards,
Ryohei Takahashi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | osumi.takamichi@fujitsu.com | 2021-08-05 08:58:35 | RE: Skipping logical replication transactions on subscriber side |
| Previous Message | Fujii Masao | 2021-08-05 08:51:25 | Re: param 'txn' not used in function maybe_send_schema() |