Re: Do we still have locking problems with concurrent users

Justin Clift wrote:
> Hi all,
>
> One of the things which the AS3AP benchmark does is have multiple users
> access a table with hash indexes on it.
>
> With the OSDB (Open Source Database Benchmark: http://osdb.sf.net) we've
> found on PG 7.1 that multiple clients hitting a table using a hash index
> generates locking problems. I remember Tom mentioning that this is a
> known thing, but I'm not sure if this has been fixed since then.
>
> Does anyone have any ideas? If not, would someone be willing to take
> the time to fix it?

It has not been fixed. One TODO item is to either stop mentioning hash
at all or get it improved. We have been sitting on the fence for too
long.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026