Re: Overusing 1 CPU
| От | J. Roeleveld |
|---|---|
| Тема | Re: Overusing 1 CPU |
| Дата | |
| Msg-id | 201006021348.21572.joost@antarean.org обсуждение исходный текст |
| Ответ на | Re: Overusing 1 CPU (Mozzi <mozzi.glug@gmail.com>) |
| Список | pgsql-performance |
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 >
В списке pgsql-performance по дате отправления: