Re: Overusing 1 CPU

From: A. Kretschmer
Subject: Re: Overusing 1 CPU
Date: ,
(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
Subject: Re: File system choice for Red Hat systems
From: venu madhav
Subject: Re: Autovacuum in postgres.