Ayo <ayo@xxxxxxxxxx> writes: > No luck. It uses the index now, but seemingly only to loop over it. The > integer version uses a HashAggregate, I must have missed something in my > implementation to make the planner avoid that node. Does it have any special > type requirements, other than the hash operator class? Hmm ... did you remember to set the oprcanhash property on the equality operator? regards, tom lane