Request a Demo
Home   >   mailing lists

Re: Reduce "Var IS [NOT] NULL" quals during constant folding - Mailing list pgsql-hackers

From Andrei Lepikhov
Subject Re: Reduce "Var IS [NOT] NULL" quals during constant folding
Date
Msg-id 0f1d231f-4290-4eba-bd17-59920565b360@gmail.com
Whole thread Raw
In response to Reduce "Var IS [NOT] NULL" quals during constant folding  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Reduce "Var IS [NOT] NULL" quals during constant folding
List pgsql-hackers
Tree view 
On 30/6/2025 09:26, Richard Guo wrote:
> On Wed, May 28, 2025 at 6:28 PM Richard Guo <guofenglinux@gmail.com> wrote:
>> Yeah, this patchset is targeted for v19.  Maybe we could be more
>> aggressive and have 0001 and 0002 in v18?  (no chance for 0003 though)
>>
>> This patchset does not apply anymore due to 2c0ed86d3.  Here is a new
>> rebase.
> 
> This patchset does not apply anymore, due to 5069fef1c this time.
> Here is a new rebase.
I like the general idea of this work. But I wonder, why is a new hash 
table designed to store only the notnullattnums field? From the 
discussion, it is not apparent why not to cache all (or most of) the 
data needed for get_relation_info. In cases where multiple subqueries 
reference the same table, it could save some cycles and memory.

-- 
regards, Andrei Lepikhov

pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Add os_page_num to pg_buffercache
Next
From: Japin Li
Date:
Subject: Re: Inconsistent LSN format in pg_waldump output