Re: Deprecating Hash Indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Deprecating Hash Indexes
Date: 2012-10-14 16:47:47
Message-ID: 26853.1350233267@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-10-14 16:50:44 Re: pg_dump restore error
Previous Message Tom Lane 2012-10-14 16:43:54 Re: pg_stat_lwlocks view - lwlocks statistics, round 2