On Wednesday 02 June 2010 13:37:37 Mozzi wrote: > Hi > > Thanx mate Create Index seems to be the culprit. > Is it normal to just use 1 cpu tho? If it is a single-threaded process, then yes. And a "Create index" on a single table will probably be single-threaded. If you now start a "create index" on a different table, a different CPU should be used for that. > > Mozzi > > On Wed, 2010-06-02 at 12:24 +0100, Matthew Wakeling wrote: > > On Wed, 2 Jun 2010, Mozzi wrote: > > > This box is basically adle @ the moment as it is still in testing yet > > > top shows high usage on just 1 of the cores. > > > > First port of call: What process is using the CPU? Run top on a fairly > > wide terminal and use the "c" button to show the full command line. > > > > Matthew > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
