Re: Index creation and maintenance_work_mem

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Index creation and maintenance_work_mem
Дата
Msg-id 200807291219.15083@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: Index creation and maintenance_work_mem  ("Francisco Reyes" <lists@stringsutils.com>)
Ответы Re: Index creation and maintenance_work_mem  ("Francisco Reyes" <lists@stringsutils.com>)
Список pgsql-general
On Tuesday 29 July 2008, "Francisco Reyes" <lists@stringsutils.com> wrote:
> On 2:53 pm 07/29/08 Alan Hodgson <ahodgson@simkin.ca> wrote:
> > --sar 2 30
>
> Linux 2.6.9-42.ELsmp (trans03)  07/29/2008
>
> 12:58:09 PM       CPU     %user     %nice   %system   %iowait     %idle
> 12:58:11 PM       all     12.44      0.00      0.06      0.00     87.50
> 12:58:13 PM       all     12.44      0.00      0.00      0.06     87.50
> 12:58:15 PM       all     12.49      0.00      0.06      0.00     87.45
> 12:58:17 PM       all     12.43      0.00      0.06      1.62     85.88
> 12:58:19 PM       all     12.38      0.00      0.06      0.00     87.55
> 12:58:21 PM       all     12.43      0.00      0.12      0.00     87.45
> 12:58:23 PM       all     12.50      0.00      0.00      0.00     87.50
> 12:58:25 PM       all     12.42      0.00      0.12      0.00     87.45
>
> Quadcore machine. Not using not even 100% of one core.
> Disk subsystem doesn't seem to be issue (no iowait).

That looks an awful lot like pegged 1/8th usage to me ... are you sure you
only have 4 cores? Hyper-threading?

>
> Based on a few links I read I thought that, holding everything else
> constant, increasing maintenance_work_mem would have helped.

Yeah, but it didn't.


--
Alan

В списке pgsql-general по дате отправления:

Предыдущее
От: "Francisco Reyes"
Дата:
Сообщение: Re: Index creation and maintenance_work_mem
Следующее
От: "Francisco Reyes"
Дата:
Сообщение: Re: Index creation and maintenance_work_mem