Postgres Pro
Downloads
Home   >   mailing lists

Re: Incremental aggregate/rollup strategy advice - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Incremental aggregate/rollup strategy advice
Date
Msg-id 20190708.172100.1413110719812606373.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Incremental aggregate/rollup strategy advice  (Morris de Oryx <morrisdeoryx@gmail.com>)
Responses Re: Incremental aggregate/rollup strategy advice  (Morris de Oryx <morrisdeoryx@gmail.com>)
List pgsql-general
Tree view 
> * Full queries will take too long, and will scale poorly. So, MATERIALIZED
> VIEW is unappealing. So, rollup tables as it's possible to update them
> incrementally.

F.Y.I. There is a proposal to implemnt incremental updation against
MATERIALIZED VIEW. It is still in WIP patch but currently it supports
count and sum.

https://www.postgresql.org/message-id/20190628195620.c306e3003a83bb85a12f54c5%40sraoss.co.jp

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

pgsql-general by date:

Previous
From: Morris de Oryx
Date:
Subject: Incremental aggregate/rollup strategy advice
Next
From: Morris de Oryx
Date:
Subject: Re: Incremental aggregate/rollup strategy advice