"Brian J. France" <postgresql(at)firehawksystems(dot)com> writes:
> I am getting a few of these errors in my web logs and didn't know what I could do to stop it.
> NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause.
> Error in query "UPDATE <table> SET <field> = <value> WHERE <field2> = <value2>" : ERROR: WaitOnLock: error on wakeup - Aborting this transaction
> Is this due to the hash index on field2 or due to the has index in general?
Don't use hash indexes for concurrent applications. I don't really know
of any reason for preferring a hash index over a btree index in any case.
regards, tom lane