Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: GiST indexes and concurrency (tsearch2)
Date
Msg-id 16719.1107448058@sss.pgh.pa.us
Whole thread Raw
In response to Re: GiST indexes and concurrency (tsearch2)  ("Marinos J. Yannikos" <mjy@geizhals.at>)
Responses Re: GiST indexes and concurrency (tsearch2)
Re: GiST indexes and concurrency (tsearch2)
List pgsql-performance
Tree view 
"Marinos J. Yannikos" <mjy@geizhals.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner really hates nested loops
Next
From: "Magnus Hagander"
Date:
Subject: Re: Planner really hates nested loops