Re: [GENERAL] Hash Indexes Causing Deadlock Notices

2000-10-18 Thread Tom Lane
mark <[EMAIL PROTECTED]> writes: > I noticed that a large number of log notice messages announcing a > deadlock being detected together with transactions being aborted > The tables impacted in the benchmark had HASH indexes. ( only = scans > were being performed, it seemed a good idea at the tim

[GENERAL] Hash Indexes Causing Deadlock Notices

2000-10-18 Thread mark
Hi, I have been experimenting with the Apache Benchmarking Tool ( ab ) to give my demo web site a bit of a hiding. The database backend is Postgresql 7.1 ( dev from 25/09/00) . I noticed that a large number of log notice messages announcing a deadlock being detected together with transactions b