Re: Evaluate expression at planning time for two more cases

From: Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>
To: Surafel Temesgen <surafel3000(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>
Subject: Re: Evaluate expression at planning time for two more cases
Date: 2021-03-08 16:12:52
Message-ID: CALtqXTc0T9Gi4sz0-_gBACOuPTV588jt+zJgDuUL=aTYkKwCSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 24, 2020 at 12:47 PM Surafel Temesgen <surafel3000(at)gmail(dot)com>
wrote:

> Hi Pavel Borisov,
> It's always good to select the optimal way even if it didn't have
> performance gain
> but in case of this patch i see 4x speed up on my laptop and it will work
> on any
> table that have NULL constraint
>
> regards
> Surafel
>

The patch (null_check_on_pkey_optimization_v2.patch) does not apply
successfully.
http://cfbot.cputube.org/patch_32_2699.log

1 out of 10 hunks FAILED -- saving rejects to file
src/backend/optimizer/util/clauses.c.rej

It was a minor change therefore I rebased the patch, please take a look.

--
Ibrar Ahmed

Attachment Content-Type Size
null_check_on_pkey_optimization_v3.patch application/octet-stream 11.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ibrar Ahmed 2021-03-08 16:15:53 Re: Yet another fast GiST build
Previous Message Andreas Karlsson 2021-03-08 16:04:15 Re: [PATCH] pg_ownerships system view