Re: Postgresql Materialized views - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Postgresql Materialized views
Date
Msg-id 20080114144723.GC11559@svana.org
Whole thread Raw
In response to Re: Postgresql Materialized views  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-hackers
On Mon, Jan 14, 2008 at 08:30:53AM -0600, Roberts, Jon wrote:
> > My point is that you should be able to query _table and the system
> > should automatically use the view, without you saying so (except by
> > initially creating them).
> >
> I agree!  From a BI perspective, a materialized view is worthless if you
> have to re-write your query.  There isn't a tool on the market that is smart
> enough to rewrite a query to a view because all other databases handle the
> rewriting internally.

I don't know about worthless, given that people are doing materialised
views on postgres already. It is however a completely orthoginal
problem. Someone needs to write the code to maintain such a view before
you can even think about working on the planner.

However, step 1 would be to get them onto the TODO list.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Postgresql Materialized views
Next
From: "Zeugswetter Andreas ADI SD"
Date:
Subject: Re: Postgresql Materialized views