Partitioned "views"

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Partitioned "views"
Date: 2017-01-22 20:51:32
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EACC42F@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

we use a materialized view to aggregate datas from a very big table containing logs.
The source table is partitioned, one table for a day.

Since the refresh of the materialized view seems to grow a lot about timing, we would like to know if it is pssible to make a "partitioned materialized views", in order to update *only* current day logs aggregation, leaving old days untouchable.

Thank you!
/F

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-01-22 20:58:15 Re: Partitioned "views"
Previous Message Amitabh Kant 2017-01-22 11:12:30 Re: pg_upgrade error on FreeBSD (9.1 -> 9.5)