Re: query rewrite using materialized views

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Yann Michel <yann-postgresql(at)spline(dot)de>
Subject: Re: query rewrite using materialized views
Date: 2005-01-04 18:06:18
Message-ID: 200501041006.18735.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Murugan Kalicharan S 2005-01-04 18:17:31 Postgres starting problem -- 7.3.4
Previous Message Jim Buttafuoco 2005-01-04 18:03:12 CSV arm check failure

Browse pgsql-performance by date

  From Date Subject
Next Message Wager, Ryan D [NTK] 2005-01-04 18:41:45 Re: query rewrite using materialized views
Previous Message Pallav Kalva 2005-01-04 14:38:04 Re: Very Bad Performance.