Re: post-freeze damage control

Hi! Unfortunately,Iwas notableto fullyunderstandyourmessage.Couldyou
explainit to meplease?

On 09.04.2024 16:20, Andrei Lepikhov wrote:
>
> Moreover, it helps even SeqScan: attempting to find a value in the
> hashed array is much faster than cycling a long-expression on each
> incoming tuple.

AsIunderstandit,youtalkedaboutspeedingupSeqScan
byfasterre-searchingthroughthe useof a hashtable. Atthe same time,
wehaveto builditbeforethat,whenthere was the initiallookuptuples,right?

Ifoundthisinformationinthe ExecEvalHashedScalarArrayOp
function,andIassumeyoumeantthisfunctioninyourmessage.

But I couldn't find information, when you told about cycling a
long-expression on each incoming tuple. Could you ask me what function
you were talking about or maybe functionality? I saw ExecSeqScan
function, but I didn't see it.

--
Regards,
Alena Rybakina
Postgres Professional:http://www.postgrespro.com
The Russian Postgres Company