Re: define pg_structiszero(addr, s, r) - Mailing list pgsql-hackers

From Ranier Vilela
Subject Re: define pg_structiszero(addr, s, r)
Date
Msg-id CAEudQAo7BpBqjP5oTGLNycux+Yi3qNa3WaSLkSVrvN9GbnhQfw@mail.gmail.com
Whole thread Raw
In response to Re: define pg_structiszero(addr, s, r)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Em seg., 28 de out. de 2024 às 12:08, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
Ranier Vilela <ranier.vf@gmail.com> writes:
> It seems to me that [reversing the loop direction] is more optimized.

That's far from clear: you're ignoring the possibility that memory
access logic is better optimized for forward scanning than reverse
scanning.  I'd stick with the forward scan without some extremely
detailed testing.
I don't disagree.
After posting, I was wondering if the first possible is not zero, it should probably be at the beginning and not at the end.

best regards,
Ranier Vilela

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER
Next
From: Jim Nasby
Date:
Subject: Planner issue with BitmapScan recheck on external TOAST