Mozzi, * Mozzi (mozzi.glug@xxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
