Re: query uses index but takes too much time?

From: Aidan Van Dyk <aidan(at)highrise(dot)ca>
To: MirrorX <mirrorx(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: query uses index but takes too much time?
Date: 2011-11-24 17:51:34
Message-ID: CAC_2qU86+2+iz90W=-rXMW4O6K6JMLkcpmXpNAY0gT3NWJXnCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Nov 24, 2011 at 12:20 PM, MirrorX <mirrorx(at)gmail(dot)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(at)highrise(dot)ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Cédric Villemain 2011-11-24 19:24:33 Re: query uses index but takes too much time?
Previous Message MirrorX 2011-11-24 17:20:31 query uses index but takes too much time?