Mozzi,
* Mozzi (mozzi.glug@gmail.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