Postgres Pro
Downloads
Home   >   mailing lists

Re: query uses index but takes too much time? - Mailing list pgsql-performance

From Aidan Van Dyk
Subject Re: query uses index but takes too much time?
Date
Msg-id CAC_2qU86+2+iz90W=-rXMW4O6K6JMLkcpmXpNAY0gT3NWJXnCw@mail.gmail.com
Whole thread Raw
In response to query uses index but takes too much time?  (MirrorX <mirrorx@gmail.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: MirrorX
Date:
Subject: query uses index but takes too much time?
Next
From: Cédric Villemain
Date:
Subject: Re: query uses index but takes too much time?