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: | 'legrand legrand' <legrand_legrand(at)hotmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Implementing Incremental View Maintenance |
Date: | 2019-12-24 07:07:35 |
Message-ID: | OSAPR01MB50732465353599538456CD2EFE290@OSAPR01MB5073.jpnprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
From: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
> On Mon, 23 Dec 2019 08:08:53 +0000
> "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> wrote:
> > How about unlogged tables ? I thought the point of using a temp table is to
> avoid WAL overhead.
>
> Hmm... this might be another option. However, if we use unlogged tables,
> we will need to create them in a special schema similar to pg_toast
> to split this from user tables. Otherwise, we need to create and drop
> unlogged tables repeatedly for each session.
Maybe we can create the work tables in the same schema as the materialized view, following:
* Prefix the table name to indicate that the table is system-managed, thus alluding to the user that manually deleting the table would break something. This is like the system attribute __imv_count you are proposing.
* Describe the above in the manual. Columns of serial and bigserial data type similarly create sequences behind the scenes.
* Make the work tables depend on the materialized view by recording the dependency in pg_depend, so that Dropping the materialized view will also drop its work tables.
Regards
Takayuki Tsunakawa
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2019-12-24 07:09:07 | Re: Online checksums verification in the backend |
Previous Message | tsunakawa.takay@fujitsu.com | 2019-12-24 06:52:35 | RE: Implementing Incremental View Maintenance |