Re: Broken resetting of subplan hash tables - Mailing list pgsql-hackers

From Ranier Vilela
Subject Re: Broken resetting of subplan hash tables
Date
Msg-id CAEudQAppnvESFqR4tq6rJZcteLw4k3aYLzmzW5E_gtMhN1cYZg@mail.gmail.com
Whole thread Raw
In response to Re: Broken resetting of subplan hash tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Em sáb., 29 de fev. de 2020 às 18:44, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
"throw it away" sure looks like it means the entire hashtable, not just
its tuple contents.
I don't know if I can comment clearly to help, but from my experience, destroying and rebuilding the hashtable is a waste if possible, resetting it.
By analogy, I have code with arrays where, I reuse them, with only one line, instead of reconstructing them.
a->nelts = 0; / * reset array * /
If possible, doing the same for hashtables would be great.
 
regards,
Ranier Vilela

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal \gcsv
Next
From: Julien Rouhaud
Date:
Subject: Re: Planning counters in pg_stat_statements (using pgss_store)