Re: query rewrite using materialized views

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: query rewrite using materialized views
Дата
Msg-id 200501041006.18735.josh@agliodbs.com
обсуждение исходный текст
Ответ на query rewrite using materialized views  (Yann Michel <yann-postgresql@spline.de>)
Ответы Re: query rewrite using materialized views  (Yann Michel <yann-postgresql@spline.de>)
Список 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 по дате отправления:

Предыдущее
От: Pallav Kalva
Дата:
Сообщение: Re: Very Bad Performance.
Следующее
От: "Wager, Ryan D [NTK]"
Дата:
Сообщение: Re: query rewrite using materialized views