Re: Let's drop two obsolete features which are bear-traps for novices - Mailing list pgsql-hackers

On 10/31/2014 03:07 PM, Tom Lane wrote:
> I don't care one way or the other about the money type, but I will defend
> hash indexes, especially seeing that we've already added a pretty
> in-your-face warning as of 9.5:
> 
> regression=# create table foo(f1 int);
> CREATE TABLE
> regression=# create index on foo using hash (f1);
> WARNING:  hash indexes are not WAL-logged and their use is discouraged
> CREATE INDEX

Yes, and I'm arguing that is the wrong decision.  If hash indexes are
"discouraged", then they shouldn't be in core in the first place.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com