Re: GiST indexes and concurrency (tsearch2)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-performance(at)postgresql(dot)org
Subject: Re: GiST indexes and concurrency (tsearch2)
Date: 2005-02-03 16:27:38
Message-ID: 16719.1107448058@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Marinos J. Yannikos" <mjy(at)geizhals(dot)at> writes:
> I can't seem to find out where the bottleneck is, but it doesn't seem to
> be CPU or disk. "top" shows that postgres processes are frequently in
> this state:

> 6701 postgres 16 0 204m 58m 56m S 9.3 0.2 0:06.96 semtimedo
> ^^^^^^^^^

What's the platform exactly (hardware and OS)?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2005-02-03 16:41:37 Re: Planner really hates nested loops
Previous Message Tom Lane 2005-02-03 16:25:31 Re: Planner really hates nested loops