Postgres Pro
Downloads
Home   >   mailing lists

Re: POC: GROUP BY optimization - Mailing list pgsql-hackers

From Pavel Borisov
Subject Re: POC: GROUP BY optimization
Date
Msg-id CALT9ZEFU60nW9TJqHUs9Ex_tqv__7t=jfF4Q=iwwxJTO0PY7Rg@mail.gmail.com
Whole thread Raw
In response to Re: POC: GROUP BY optimization  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: POC: GROUP BY optimization  (Dmitry Dolgov <9erthalion6@gmail.com>)
List pgsql-hackers
Tree view

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
Attachment

pgsql-hackers by date:

Previous
From: Zhenghua Lyu
Date:
Subject: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0?
Next
From: Pavel Stehule
Date:
Subject: Re: default result formats setting