Postgres Pro
Downloads
Home   >   mailing lists

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

From Alan Hodgson
Subject Re: Index creation and maintenance_work_mem
Date
Msg-id 200807291153.26908@hal.medialogik.com
Whole thread Raw
In response to Index creation and maintenance_work_mem  ("Francisco Reyes" <lists@stringsutils.com>)
Responses Re: Index creation and maintenance_work_mem
List pgsql-general
Tree view 
On Tuesday 29 July 2008, "Francisco Reyes" <lists@stringsutils.com> wrote:
> Besides maintenance_work_mem, what else can be changed to improve index
> creation?
>

Depends where the bottleneck is.

1 CPU core 100% user/system = buy faster CPU cores.

System in I/O wait = upgrade disk channel.

--
Alan

pgsql-general by date:

Previous
From: "Valter Douglas Lisbôa Jr."
Date:
Subject: Re: How do I convert a timestamp with time zone to local time?
Next
From: "Francisco Reyes"
Date:
Subject: Re: Index creation and maintenance_work_mem