| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | li(dot)evan(dot)chao(at)gmail(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org, ojford(at)gmail(dot)com |
| Subject: | Re: Should IGNORE NULLS cache nullness for volatile arguments? |
| Date: | 2026-05-15 07:34:25 |
| Message-ID: | 20260515.163425.1708559652740041584.ishii@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>> @@ -3454,7 +3455,10 @@ ignorenulls_getfuncarginframe(WindowObject winobj, int argno,
>> if (isout)
>> *isout = false;
>>
>> - v = get_notnull_info(winobj, abs_pos, argno);
>> + if (winobj->notnull_info_cacheable[argno])
>>
>> What about moving this if statement inside get_notnull_info() so that
>> the caller does not care about this argno is cacheable or not?
>>
>> + /* record the row status if it is safe to reuse */
>> + if (winobj->notnull_info_cacheable[argno])
>> + put_notnull_info(winobj, abs_pos, argno, *isnull);
>>
>> Similary, we can move "if (winobj->notnull_info_cacheable[argno])" inside put_notnull_info().
>>
>
> Yep, good idea. Addressed in attached v2.
Thanks for the v2 patch. It looks good to me. I am going to push the
patch within a few days if there's no objection.
Regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2026-05-15 08:16:38 | Re: Simplify signature of ProcessStartupPacket() |
| Previous Message | Peter Smith | 2026-05-15 07:19:03 | Re: Support EXCEPT for TABLES IN SCHEMA publications |