Re: [HACKERS] Secondary index access optimizations

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [HACKERS] Secondary index access optimizations
Date: 2017-12-04 17:18:42
Message-ID: 700770fd-82a3-4eb6-b397-546ab5158dc9@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

On 04.12.2017 19:44, Alvaro Herrera wrote:
> Konstantin Knizhnik wrote:
>>
>> On 30.11.2017 05:16, Michael Paquier wrote:
>>> On Mon, Nov 6, 2017 at 10:13 PM, Konstantin Knizhnik
>>> <k(dot)knizhnik(at)postgrespro(dot)ru> wrote:
>>>> Concerning broken partition_join test: it is "expected" failure: my patch
>>>> removes from the plans redundant checks.
>>>> So the only required action is to update expected file with results.
>>>> Attached please find updated patch.
>>> The last patch version has conflicts in regression tests and did not
>>> get any reviews. Please provide a rebased version. I am moving the
>>> patch to next CF with waiting on author as status. Thanks!
>> Rebased patch is attached.
> I don't think this is a rebase on the previously posted patch ... it's
> about 10x as big and appears to be a thorough rewrite of the entire
> optimizer.
>

Or, sorry. I really occasionally committed in this branch patch for
aggregate push down.
Correct reabased patch is attached.

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
optimizer-6.patch text/x-patch 41.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2017-12-04 17:40:18 Re: [HACKERS] WIP: Covering + unique indexes.
Previous Message Tom Lane 2017-12-04 17:05:26 Re: Errands around AllocateDir()