Re: GiST indexes and concurrency (tsearch2) - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: GiST indexes and concurrency (tsearch2)
Date
Msg-id 4201EED4.60606@familyhealth.com.au
Whole thread Raw
In response to GiST indexes and concurrency (tsearch2)  ("Marinos J. Yannikos" <mjy@geizhals.at>)
List 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 by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Accessing insert values in triggers
Next
From: Din Adrian
Date:
Subject: Tunning postgresql on linux (fedora core 3)