Re: Multicolumn hash indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomasz Ostrowski <tometzky+pg(at)ato(dot)waw(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multicolumn hash indexes
Date: 2017-09-26 23:18:41
Message-ID: 20188.1506467921@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tomasz Ostrowski <tometzky+pg(at)ato(dot)waw(dot)pl> writes:
> I've noticed that hash indexes can't currently (in PG10) be multicolumn.
> Are they technically hard to implement or just nobody took such a feature?

It's not simple, particularly not if you wish that the index would support
queries specifying conditions for just a subset of the indexed columns
(an assumption that's buried pretty deeply in the planner, for one thing).
Then you couldn't compute the hash.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-09-26 23:21:43 Re: Multicolumn hash indexes
Previous Message Jeff Janes 2017-09-26 23:05:46 Re: v10 pg_ctl compatibility