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