Re: Index creation and maintenance_work_mem - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Index creation and maintenance_work_mem
Date
Msg-id 7634e33ce8adc72503357324d8a0d386@stringsutils.com
Whole thread Raw
In response to Re: Index creation and maintenance_work_mem  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: Index creation and maintenance_work_mem
List 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 by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Index creation and maintenance_work_mem
Next
From: Alan Hodgson
Date:
Subject: Re: Index creation and maintenance_work_mem