Re: Overusing 1 CPU

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Mozzi <mozzi(dot)glug(at)gmail(dot)com>
Cc: Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Overusing 1 CPU
Date: 2010-06-02 11:59:16
Message-ID: 20100602115916.GE21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mozzi,

* Mozzi (mozzi(dot)glug(at)gmail(dot)com) 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joachim Worringen 2010-06-02 12:54:22 Re: performance of temporary vs. regular tables
Previous Message A. Kretschmer 2010-06-02 11:58:59 Re: Overusing 1 CPU