Re: query rewrite using materialized views - Mailing list pgsql-performance

From Josh Berkus
Subject Re: query rewrite using materialized views
Date
Msg-id 200501041006.18735.josh@agliodbs.com
Whole thread Raw
In response to query rewrite using materialized views  (Yann Michel <yann-postgresql@spline.de>)
Responses Re: query rewrite using materialized views  (Yann Michel <yann-postgresql@spline.de>)
List pgsql-performance
Yann,

> are there any plans for rewriting queries to preexisting materialized
> views?  I mean, rewrite a query (within the optimizer) to use a
> materialized view instead of the originating table?

Automatically, and by default, no.   Using the RULES system?  Yes, you can
already do this and the folks on the MattView project on pgFoundry are
working to make it easier.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Pallav Kalva
Date:
Subject: Re: Very Bad Performance.
Next
From: "Wager, Ryan D [NTK]"
Date:
Subject: Re: query rewrite using materialized views