[GENERAL] Partitioned "views" - Mailing list pgsql-general

From Job
Subject [GENERAL] Partitioned "views"
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC42F@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: [GENERAL] Partitioned "views"  (Stephen Frost <sfrost@snowman.net>)
List 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

pgsql-general by date:

Previous
From: Amitabh Kant
Date:
Subject: Re: [GENERAL] pg_upgrade error on FreeBSD (9.1 -> 9.5)
Next
From: Stephen Frost
Date:
Subject: Re: [GENERAL] Partitioned "views"