Re: Bogus startup cost for WindowAgg

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bogus startup cost for WindowAgg
Дата
Msg-id 29317.1286991022@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bogus startup cost for WindowAgg  (Ants Aasma <ants.aasma@eesti.ee>)
Список pgsql-performance
Ants Aasma <ants.aasma@eesti.ee> writes:
> Seems that the window aggregate node doesn't take into account that it
> has to consume the whole input before outputting the first row.

Well, the reason it doesn't assume that is it's not true ;-).  In this
particular case it's true, but more generally you only have to read the
current input partition, and often not even all of that.

I'm not sure offhand how much intelligence would have to be added to
make a reasonable estimate of the effects of having to read ahead of the
current input row, but it's probably not trivial.  We haven't spent much
time at all yet on creating a realistic cost model for WindowAgg...

            regards, tom lane

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

Предыдущее
От: Neil Whelchel
Дата:
Сообщение: Re: Slow count(*) again...
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Slow count(*) again...