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

Поиск
Список
Период
Сортировка
От Justin Clift
Тема Do we still have locking problems with concurrent users of hash tables?
Дата
Msg-id 3C857CE5.1DC11658@postgresql.org
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: ext2 vs ext3 vs RAID5 (software) benchmark
Следующее
От: mlw
Дата:
Сообщение: Vacuum daemon (pgvacuumd ?)