Re: Postgresql Materialized views

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