Re: Incremental aggregate/rollup strategy advice

From: Morris de Oryx <morrisdeoryx(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Incremental aggregate/rollup strategy advice
Date: 2019-07-08 09:16:00
Message-ID: CAKqnccjE8PQsjoaXqe=qaMKReZ=0iizbFSwRuWRdr59uvw+vpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tatsuo,

Thank you for your response, I have followed the discussion on Hackers with
interest. I hope that your efforts are a great success! In my case, I need
to find a solution available in shipping versions of Postgres. But, since
you've joined in, I'm curious: What is the advantage of a materialized view
over a real table? It seems like the update semantics and mechanics are
more straightforward with a table.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Winfield 2019-07-08 13:02:53 RE: Incremental aggregate/rollup strategy advice
Previous Message Tatsuo Ishii 2019-07-08 08:21:00 Re: Incremental aggregate/rollup strategy advice