Re: GiST indexes and concurrency (tsearch2)

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: GiST indexes and concurrency (tsearch2)
Date: 2005-02-03 09:28:52
Message-ID: 4201EED4.60606@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Din Adrian 2005-02-03 09:55:04 Tunning postgresql on linux (fedora core 3)
Previous Message Michael Fuhr 2005-02-03 08:01:42 Re: [PERFORM] Accessing insert values in triggers