Re: Incremental aggregate/rollup strategy advice

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: morrisdeoryx(at)gmail(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Incremental aggregate/rollup strategy advice
Date: 2019-07-08 08:21:00
Message-ID: 20190708.172100.1413110719812606373.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> * 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Morris de Oryx 2019-07-08 09:16:00 Re: Incremental aggregate/rollup strategy advice
Previous Message Morris de Oryx 2019-07-08 07:48:30 Incremental aggregate/rollup strategy advice