Re: check for null value before looking up the hash function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: check for null value before looking up the hash function
Date
Msg-id 487989.1653078782@sss.pgh.pa.us
Whole thread Raw
In response to check for null value before looking up the hash function  (Zhihong Yu <zyu@yugabyte.com>)
List pgsql-hackers
Zhihong Yu <zyu@yugabyte.com> writes:
> I was looking at the code in hash_record()
> of src/backend/utils/adt/rowtypes.c
> It seems if nulls[i] is true, we don't need to look up the hash function.

I don't think this is worth changing.  It complicates the logic,
rendering it unlike quite a few other functions written in the same
style.  In cases where the performance actually matters, the hash
function is cached across multiple calls anyway.  You might save
something if you have many calls in a query and not one of them
receives a non-null input, but how likely is that?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Zstandard support for toast compression
Next
From: Tom Lane
Date:
Subject: Re: CPU time for pg_stat_statement