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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers