[GENERAL] Partitioned "views"

Поиск
Список
Период
Сортировка
От Job
Тема [GENERAL] Partitioned "views"
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC42F@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответы Re: [GENERAL] Partitioned "views"
Список 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 по дате отправления: