Re: pgsql: Fix building of large (bigger than shared_buffers) hash indexes. - Mailing list pgsql-committers

From Peter Geoghegan
Subject Re: pgsql: Fix building of large (bigger than shared_buffers) hash indexes.
Date
Msg-id CAM3SWZR9ei4nHxutYCvT6x4BqZvrhDaNAvxAzJYodu6-C3fuUA@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Fix building of large (bigger than shared_buffers) hash indexes.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-committers
On Mon, Jun 27, 2016 at 2:27 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Do we have any way of helping people find out if they need to recreate
> their hash indexes?

No, but I don't think that it's especially needed. It ought to be
completely obvious when the problem arises, because the resulting
index is total garbage.

This tells us a lot about how many people use hash indexes in
production, of course. 9.5 has been out for months.

--
Peter Geoghegan


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql: Fix building of large (bigger than shared_buffers) hash indexes.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Fix building of large (bigger than shared_buffers) hash indexes.