DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=Kt1zRndYs7n4eAr839vzIh5GEs0ClLK7KANmhIjyqZ8AofDMK+3rQpdRg/ZIH374/b3wFJbqQE8CQr9YVaIdyRaCeWWxQnESPp/0KkSQZ14Y774mQO3AyQnp3J81t6+mmzlInnPyqHqp4SYigzTcBShe5eds97rH2O1AQr4d4IQ=
Message-ID: <dcc563d10710191121r155aa4a3p5b5916bc512f6370@mail.gmail.com>
Date: Fri, 19 Oct 2007 13:21:26 -0500
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Yinan Li" <yinanli@cse.ust.hk>
Subject: Re: how to improve the performance of creating index
Cc: pgsql-performance@postgresql.org
In-Reply-To: <01c601c81247$3b8c5650$b2a502f0$@ust.hk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <01c601c81247$3b8c5650$b2a502f0$@ust.hk>

On 10/19/07, Yinan Li <yinanli@cse.ust.hk> wrote:
>
> Hi, all
>          I am trying to improve the performance of creating index.
>          I've set shared_buffers = 1024MB
>                    Effective_cache_size = 1024MB
>                    Work_mem = 1GB
>                    Maintenance_work_mem=512MB
>          (I'm sure that the server process has received the SIGHUP signal)
>
> However, when create index, I found that the memory used by Postgres is only
> 50MB. And it is very slow. How to make it faster?

What, exactly is the create index statement? I assume that if there's
only two columns then at worst it's a two part index (i.e. column1,
column2)  which can get rather large.