| From: | "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> |
|---|---|
| To: | 'Yugo Nagata' <nagata(at)sraoss(dot)co(dot)jp> |
| Cc: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, "michael(at)paquier(dot)xyz" <michael(at)paquier(dot)xyz>, "amitlangote09(at)gmail(dot)com" <amitlangote09(at)gmail(dot)com>, Takuma Hoshiai <hoshiai(at)sraoss(dot)co(dot)jp>, "alvherre(at)2ndquadrant(dot)com" <alvherre(at)2ndquadrant(dot)com>, "thomas(dot)munro(at)gmail(dot)com" <thomas(dot)munro(at)gmail(dot)com>, "kgrittn(at)gmail(dot)com" <kgrittn(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RE: Implementing Incremental View Maintenance |
| Date: | 2019-12-20 07:12:23 |
| Message-ID: | OSAPR01MB5073D680E1FB8AA4DA8EAAF7FE2D0@OSAPR01MB5073.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
I'm starting to take a closer look at this feature. I've just finished reading the discussion, excluding other referenced materials.
The following IVM wiki page returns an error. Does anybody know what's wrong?
https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
[screen]
----------
MediaWiki internal error.
Exception caught inside exception handler.
Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to show detailed debugging information.
----------
Could you give some concrete use cases, so that I can have a clearer image of the target data? In the discussion, someone referred to master data with low update frequency, because the proposed IVM implementation adds triggers on source tables, which limits the applicability to update-heavy tables.
Regards
Takayuki Tsunakawa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-12-20 07:20:18 | Re: Hooks for session start and end, take two |
| Previous Message | Masahiko Sawada | 2019-12-20 06:43:22 | Re: [HACKERS] Block level parallel vacuum |