R: Partitioned "views"

From: Job <Job(at)colliniconsulting(dot)it>
To: 'Stephen Frost' <sfrost(at)snowman(dot)net>, Job <Job(at)colliniconsulting(dot)it>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: R: Partitioned "views"
Date: 2017-01-22 21:29:44
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EACC430@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Stephen.

>>The mat view takes longer and longer to update because it runs the full query. What you really want to do is have a side-table that you update regularly with appropriate SQL to issue UPDATE statements for just the current day (or whatever).

If correct, i leave only last datas into "side-table" and syncronize only these datas in the materialized view.
If i delete datas from the side-table (ex- truncate) during the next materialized view update they will be lost or remain intact?

Thank you
Francesco

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-01-22 21:37:51 Re: R: Partitioned "views"
Previous Message Stephen Frost 2017-01-22 20:58:15 Re: Partitioned "views"