Re: GiST indexes and concurrency (tsearch2)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GiST indexes and concurrency (tsearch2)
Дата
Msg-id 16719.1107448058@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GiST indexes and concurrency (tsearch2)  ("Marinos J. Yannikos" <mjy@geizhals.at>)
Ответы Re: GiST indexes and concurrency (tsearch2)  ("Marinos J. Yannikos" <mjy@geizhals.at>)
Re: GiST indexes and concurrency (tsearch2)  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-performance
"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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Planner really hates nested loops
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Planner really hates nested loops