От: A. Kretschmer
Тема: Re: Overusing 1 CPU
Дата: ,
Msg-id: 20100602115859.GA5335@a-kretschmer.de
(см: обсуждение, исходный текст)
Ответ на: Re: Overusing 1 CPU  (Mozzi)
Список: pgsql-performance

Скрыть дерево обсуждения

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 по дате сообщения:

От: Wales Wang
Сообщение: Re: File system choice for Red Hat systems
От: venu madhav
Сообщение: Re: Autovacuum in postgres.