Re: MAX/MIN optimization via rewrite (plus query

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: MAX/MIN optimization via rewrite (plus query
Дата
Msg-id 87sm7gdz3f.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: MAX/MIN optimization via rewrite (plus query  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:

> On Wed, 2004-11-10 at 22:48, Mark Kirkwood wrote:
> > Planning for future note: I would like whatever mechanism that is added 
> > for this MAX/MIN stuff to be amenable to more subtle things like 
> > aggregate navigation (see R.Kimball's article 
> > http://www.dbmsmag.com/9608d54.html).
> > 
> 
> With you on that one...

This looks like more of a materialized views application than anything to do
with planning aggregate functions. Materialized views are most useful when the
materialized view is smaller than the original data and therefore usually
involve aggregates, but it's not necessary.

-- 
greg



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: MAX/MIN optimization via rewrite (plus query rewrites generally)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: MAX/MIN optimization via rewrite (plus query rewrites generally)