From: Scott Marlowe <scott.marlowe@gmail.com>
To: Yinan Li <yinanli@cse.ust.hk>
Cc: pgsql-performance@postgresql.org
Subject: Re: how to improve the performance of creating index
Date: Fri, 19 Oct 2007 13:21:26 -0500
Message-ID: <dcc563d10710191121r155aa4a3p5b5916bc512f6370@mail.gmail.com> (raw)
In-Reply-To: <01c601c81247$3b8c5650$b2a502f0$@ust.hk>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, yinanli@cse.ust.hk
Subject: Re: how to improve the performance of creating index
In-Reply-To: <dcc563d10710191121r155aa4a3p5b5916bc512f6370@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox