Re: query uses index but takes too much time?

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: query uses index but takes too much time?
Дата
Msg-id CAC_2qU86+2+iz90W=-rXMW4O6K6JMLkcpmXpNAY0gT3NWJXnCw@mail.gmail.com
обсуждение исходный текст
Ответ на query uses index but takes too much time?  (MirrorX <mirrorx@gmail.com>)
Список pgsql-performance
On Thu, Nov 24, 2011 at 12:20 PM, MirrorX <mirrorx@gmail.com> wrote:

> -32 cores,

> -not cpu bound (the cpu util was about 5% when i performed the tests)

A single query will only use a single CPU.

5% of 32 cores is 100% of 1.6 cores.

Are you sure that the 1 core doing the 1 postgresql query wasn't 100% utilized?

a.

--
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

В списке pgsql-performance по дате отправления:

Предыдущее
От: MirrorX
Дата:
Сообщение: query uses index but takes too much time?
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: query uses index but takes too much time?