Re: POC: GROUP BY optimization

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>, Белялов Дамир Наилевич <d(dot)belyalov(at)postgrespro(dot)ru>, Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Subject: Re: POC: GROUP BY optimization
Date: 2023-09-13 05:21:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Here is the patch rebased on the current master. Also, I fixed some
minor slips and one static analyzer warning.
This is just for adding to the next commitfest and enforcing work with
this patch.

One extra difference in newly added postgres_fdw tests is caused by this
patch - see changes in the query plan in attachment.

Andrey Lepikhov
Postgres Professional

Attachment Content-Type Size
0001-When-evaluating-a-query-with-a-multi-column-GROUP-BY-20230913.patch text/plain 97.4 KB
postgres_fdw.diff text/plain 1.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-09-13 05:27:37 Re: persist logical slots to disk during shutdown checkpoint
Previous Message Tatsuo Ishii 2023-09-13 05:14:07 Re: Row pattern recognition