Re: Overusing 1 CPU - Mailing list pgsql-performance

From A. Kretschmer
Subject Re: Overusing 1 CPU
Date
Msg-id 20100602115859.GA5335@a-kretschmer.de
Whole thread Raw
In response to Re: Overusing 1 CPU  (Mozzi <mozzi.glug@gmail.com>)
List pgsql-performance
In response to Mozzi :
> Hi
>
> Thanx mate Create Index seems to be the culprit.
> Is it normal to just use 1 cpu tho?

If you have only one client, yes. If you have more then one active
connections, every connection will use one CPU. In your case: create
index can use only one CPU.


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

pgsql-performance by date:

Previous
From: Mozzi
Date:
Subject: Re: Overusing 1 CPU
Next
From: Stephen Frost
Date:
Subject: Re: Overusing 1 CPU