Re: Materialized views WIP patch - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Materialized views WIP patch
Date
Msg-id 50B38879.1070307@dunslane.net
Whole thread Raw
In response to Re: Materialized views WIP patch  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On 11/26/2012 09:46 AM, Peter Eisentraut wrote:
> On 11/14/12 9:28 PM, Kevin Grittner wrote:
>> 17. Since the data viewed in an MV is not up-to-date with the latest
>>      committed transaction,
> So, the way I understand it, in Oracle terms, this feature is a
> "snapshot", not a materialized view.  Maybe that's what it should be
> called then.
>
>


If you use Jonathan Gardner's taxonomy at 
<http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views>, 
snapshots are a subclass of materialized views.

cheers

andrew




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Materialized views WIP patch
Next
From: David Fetter
Date:
Subject: Re: Materialized views WIP patch