Do we still have locking problems with concurrent users of hash tables?

From: Justin Clift <justin(at)postgresql(dot)org>
To: PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Do we still have locking problems with concurrent users of hash tables?
Date: 2002-03-06 02:20:21
Message-ID: 3C857CE5.1DC11658@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2002-03-06 02:21:42 Vacuum daemon (pgvacuumd ?)
Previous Message Neil Conway 2002-03-06 01:27:54 Re: ext2 vs ext3 vs RAID5 (software) benchmark