[GENERAL] Partitioned "views"

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

Предыдущее
От: Amitabh Kant
Дата:
Сообщение: Re: [GENERAL] pg_upgrade error on FreeBSD (9.1 -> 9.5)
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [GENERAL] Partitioned "views"