David Rowley <david.row...@2ndquadrant.com> writes: > On Mon, 8 Apr 2019 at 02:59, Tom Lane <t...@sss.pgh.pa.us> wrote: >> We *should* be using hash_get_num_entries(), but only to verify >> that the table is empty before resetting it. The additional bit >> that is needed is to see whether the number of buckets is large >> enough to justify calling the table bloated.
> The reason I thought it was a good idea to track some history there > was to stop the lock table constantly being shrunk back to the default > size every time a simple single table query was executed. I think that's probably gilding the lily, considering that this whole issue is pretty new. There's no evidence that expanding the local lock table is a significant drag on queries that need a lot of locks. regards, tom lane