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

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

pgsql-general by date

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

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