Re: Window Function "Run Conditions"

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Window Function "Run Conditions"
Дата
Msg-id CADkLM=eysxtm6fqquPa3fZKQVB_8wvXA_ooPB5iFz4e-0PdV7Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Window Function "Run Conditions"  (Greg Stark <stark@mit.edu>)
Ответы Re: Window Function "Run Conditions"  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers


On Tue, Mar 15, 2022 at 5:24 PM Greg Stark <stark@mit.edu> wrote:
This looks like an awesome addition.

I have one technical questions...

Is it possible to actually transform the row_number case into a LIMIT
clause or make the planner support for this case equivalent to it (in
which case we can replace the LIMIT clause planning to transform into
a window function)?

The reason I ask is because the Limit plan node is actually quite a
bit more optimized than the general window function plan node. It
calculates cost estimates based on the limit and can support Top-N
sort nodes.

But the bigger question is whether this patch is ready for a committer
to look at? Were you able to resolve Andy Fan's bug report? Did you
resolve the two questions in the original email?

+1 to all this

It seems like this effort would aid in implementing what some other databases implement via the QUALIFY clause, which is to window functions what HAVING is to aggregate functions.
 

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: pg_tablespace_location() failure with allow_in_place_tablespaces
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats