Re: Index creation and maintenance_work_mem

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Index creation and maintenance_work_mem
Дата
Msg-id 7634e33ce8adc72503357324d8a0d386@stringsutils.com
обсуждение исходный текст
Ответ на Re: Index creation and maintenance_work_mem  (Alan Hodgson <ahodgson@simkin.ca>)
Ответы Re: Index creation and maintenance_work_mem  (Alan Hodgson <ahodgson@simkin.ca>)
Список pgsql-general
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).

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


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

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