Re: matview niceties: pick any two of these three

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: matview niceties: pick any two of these three
Date: 2013-05-03 19:49:55
Message-ID: 518414E3.40108@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5/2/13 6:00 PM, Kevin Grittner wrote:
> (1) The ability to count on the results from a query which
> references a matview to reflect valid data from *some* point in
> time.
>
> (2) The ability to create unlogged materialized views.
>
> (3) The ability to consider a zero-length matview heap and a
> matview heap with allocated-but-empty pages as logically identical.

I have thought from the very beginning that violating (3) was totally
weird. I would ditch (2) in favor of (3).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2013-05-03 20:01:34 Re: matview niceties: pick any two of these three
Previous Message Tom Lane 2013-05-03 19:10:21 Re: matview niceties: pick any two of these three