We've just discovered a rather nasty feature of hashes, namely that
simultaneous reads & writes to a single row will deadlock if there
is a hash index on the table.
I guess this is because PG really has to lock the hash table entry in
both cases. It does, however, make HASH indices completely useless for
any table that you might want to update.
Is this a known feature?
Stephen