On Wed, Apr 30, 2014 at 2:02 PM, Peter Geoghegan <p...@heroku.com> wrote: >> Of course our current hash indexes have *more* not less contention >> than btree but I'm pretty comfortable chalking that up to quality of >> implementation rather than anything intrinsic. > > I am not convinced of that.
In commit 76837c1507cb5a5a0048046233568447729e66dd, I remove part (basically half) of the heavyweight locking used by hash indexes, and performance improved rather dramatically: http://www.postgresql.org/message-id/CA+Tgmoaf=nojxlyzgcbrry+pe-0vll0vfhi6tjdm3fftvws...@mail.gmail.com I think it's quite reasonable to suppose that getting rid of the remaining heavyweight locking will help just as much. -- 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