Re: Postgresql Materialized views - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Postgresql Materialized views
Date
Msg-id 1200172751.4266.1411.camel@ebony.site
Whole thread Raw
In response to Postgresql Materialized views  (Jean-Michel Pouré <jm@poure.com>)
Responses Re: Postgresql Materialized views  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-hackers
On Sat, 2008-01-12 at 13:27 +0100, Jean-Michel Pouré wrote:

> Please pick-up this important issue for developpers. There is no need to
> concentrate on complex issues, when handling materialized views could
> boost somme web apps. by a factor of 10 or more.

It's more complex than you think, but the main reason was that HOT was a
prerequisite for making summary tables work efficiently, which is only
now just about to go live into 8.3

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Transaction Snapshot Cloning
Next
From: Tom Lane
Date:
Subject: Re: Transaction Snapshot Cloning