Re: Deprecating Hash Indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Deprecating Hash Indexes
Date
Msg-id 26853.1350233267@sss.pgh.pa.us
Whole thread Raw
In response to Deprecating Hash Indexes  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Deprecating Hash Indexes  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> As discussed on other threads, Hash Indexes are currently a broken
> feature and bring us into disrepute.

Yeah ...

> Suggested actions are

I find it curious that you don't even bother to list "add WAL support to
hash indexes" as a possible solution.  It's certainly doable, and
probably not even very much more work than something like moving hash
support to a contrib module would be.  (Assuming that's even possible,
which I doubt, because the core code relies on hash index opclasses even
if not on hash indexes.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_stat_lwlocks view - lwlocks statistics, round 2
Next
From: Tom Lane
Date:
Subject: Re: pg_dump restore error