Do we still have locking problems with concurrent users of hash tables? - Mailing list pgsql-hackers

From Justin Clift
Subject Do we still have locking problems with concurrent users of hash tables?
Date
Msg-id 3C857CE5.1DC11658@postgresql.org
Whole thread Raw
Responses Re: Do we still have locking problems with concurrent users  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Do we still have locking problems with concurrent  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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?

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."  - Indira Gandhi


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: ext2 vs ext3 vs RAID5 (software) benchmark
Next
From: mlw
Date:
Subject: Vacuum daemon (pgvacuumd ?)