Re: GiST indexes and concurrency (tsearch2)

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: GiST indexes and concurrency (tsearch2)
Дата
Msg-id 4201EED4.60606@familyhealth.com.au
обсуждение исходный текст
Ответ на GiST indexes and concurrency (tsearch2)  ("Marinos J. Yannikos" <mjy@geizhals.at>)
Список pgsql-performance
> It seems to be a big problem with tsearch2, when multiple clients are
> hammering the db (we have a quad opteron box here that stays 75% idle
> despite an apachebench with concurrency 10 stressing the php script that
> uses tsearch2, with practically no disk accesses)

Concurrency with READs is fine - but you can only have one WRITE going
at once.

Chris

В списке pgsql-performance по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Accessing insert values in triggers
Следующее
От: Din Adrian
Дата:
Сообщение: Tunning postgresql on linux (fedora core 3)