От: Stephen Frost
Тема: Re: Overusing 1 CPU
Дата: ,
Msg-id: 20100602115916.GE21875@tamriel.snowman.net
(см: обсуждение, исходный текст)
Ответ на: 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", )

Mozzi,

* Mozzi () wrote:
> Thanx mate Create Index seems to be the culprit.
> Is it normal to just use 1 cpu tho?

Yes, PG can only use 1 CPU for a given query or connection.  You'll
start to see the other CPUs going when you have more than one connection
to the database.  If you're building alot of indexes then you probably
want to split up the statements into multiple connections and run them
in parallel.

    Thanks,

        Stephen

Вложения

В списке pgsql-performance по дате сообщения:

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