Re: Overusing 1 CPU

From: A. Kretschmer
Subject: Re: Overusing 1 CPU
Date: ,
Msg-id: 20100602115859.GA5335@a-kretschmer.de
(view: Whole thread, Raw)
In response to: Re: Overusing 1 CPU  (Mozzi)
List: pgsql-performance

Tree view

Overusing 1 CPU  (Mozzi, )
 Re: Overusing 1 CPU  (Matthew Wakeling, )
  Re: Overusing 1 CPU  (Mozzi, )
   Re: Overusing 1 CPU  ("A. Kretschmer", )
   Re: Overusing 1 CPU  (Stephen Frost, )
   Re: Overusing 1 CPU  ("J. Roeleveld", )

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:

From: Wales Wang
Date:
Subject: Re: File system choice for Red Hat systems
From: venu madhav
Date:
Subject: Re: Autovacuum in postgres.