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