Skip site navigation (1) Skip section navigation (2)

Re: Index creation and maintenance_work_mem

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 (view raw or flat)
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.


In response to

Responses

pgsql-general by date

Next:From: Alan HodgsonDate: 2008-07-29 19:19:14
Subject: Re: Index creation and maintenance_work_mem
Previous:From: Alan HodgsonDate: 2008-07-29 18:53:26
Subject: Re: Index creation and maintenance_work_mem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group