Re: Index creation and maintenance_work_mem

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: " Pgsql General list " <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index creation and maintenance_work_mem
Date: 2008-07-29 18:53:26
Message-ID: 200807291153.26908@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 29 July 2008, "Francisco Reyes" <lists(at)stringsutils(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2008-07-29 19:03:35 Re: Index creation and maintenance_work_mem
Previous Message Valter Douglas Lisbôa Jr. 2008-07-29 18:36:23 Re: How do I convert a timestamp with time zone to local time?