| From: | "Francisco Reyes" <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index creation and maintenance_work_mem |
| Date: | 2008-07-29 19:03:35 |
| Message-ID: | 7634e33ce8adc72503357324d8a0d386@stringsutils.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2:53 pm 07/29/08 Alan Hodgson <ahodgson(at)simkin(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2008-07-29 19:19:14 | Re: Index creation and maintenance_work_mem |
| Previous Message | Alan Hodgson | 2008-07-29 18:53:26 | Re: Index creation and maintenance_work_mem |