On Sun, Oct 14, 2012 at 9:45 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > * Put WARNINGs in the docs against the use of hash indexes, backpatch > to 8.3. CREATE INDEX gives no warning currently, though Index Types > does mention a caution.
I'd be in favor of adding such warnings to the documentation if they are not there already, and possibly even warning on CREATE INDEX .. USING hash(). I don't think I'd go so far as to say that we should imply that they'll be removed in a future release. Given how deeply intertwined they are with the planner, I doubt that that will happen; and I think there is enough interest in the technology that it's likely to eventually be fixed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers