On Fri, Jun 24, 2016 at 08:57:47PM +0000, Tom Lane wrote: > Fix building of large (bigger than shared_buffers) hash indexes. > > When the index is predicted to need more than NBuffers buckets, > CREATE INDEX attempts to sort the index entries by hash key before > insertion, so as to reduce thrashing. This code path got broken by > commit 9f03ca915196dfc8, which overlooked that _hash_form_tuple() is not > just an alias for index_form_tuple(). The index got built anyway, but > with garbage data, so that searches for pre-existing tuples always > failed. Fix by refactoring to separate construction of the indexable > data from calling index_form_tuple(). > > Per bug #14210 from Daniel Newman. Back-patch to 9.5 where the > bug was introduced. > > Report: <[email protected]>
Do we have any way of helping people find out if they need to recreate their hash indexes? -- Bruce Momjian <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
