Re: Broken resetting of subplan hash tables

Поиск
Список
Период
Сортировка
От Ranier Vilela
Тема Re: Broken resetting of subplan hash tables
Дата
Msg-id CAEudQAppnvESFqR4tq6rJZcteLw4k3aYLzmzW5E_gtMhN1cYZg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Broken resetting of subplan hash tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal \gcsv
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Planning counters in pg_stat_statements (using pgss_store)