Re: POC: GROUP BY optimization

Поиск
Список
Период
Сортировка
От Pavel Borisov
Тема Re: POC: GROUP BY optimization
Дата
Msg-id CALT9ZEFU60nW9TJqHUs9Ex_tqv__7t=jfF4Q=iwwxJTO0PY7Rg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: POC: GROUP BY optimization  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: POC: GROUP BY optimization  (Dmitry Dolgov <9erthalion6@gmail.com>)
Список pgsql-hackers
Дерево обсуждения

I wonder if anyone has plans to try again with this optimization in v14
cycle? The patches no longer apply thanks to the incremental sort patch,
but I suppose fixing that should not be extremely hard.

I found this feature interesting and I'd like to join. 
PFA the updated version of the patch made fully compatible with changes in v13 and I suppose it is ready to be reviewed for v14.

Main things changed:
1. Patch is made compatible with new lists representation ( 1cff1b95ab6d )
2. Patch is made compatible with the incremental sort ( d2d8a229bc58 and ba3e76cc571e )
3. Tests are changed to represent changes in keys numbering and naming convention in the plan ( 55a1954da16 and 6ef77cf46e8 )

As always your ideas are very much welcome!

--
Best regards,
Pavel Borisov

Postgres Professional: http://postgrespro.com
Вложения

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

Предыдущее
От: Zhenghua Lyu
Дата:
Сообщение: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: default result formats setting