how to improve the performance of creating index - Mailing list pgsql-performance

From Yinan Li
Subject how to improve the performance of creating index
Date
Msg-id 01c601c81247$3b8c5650$b2a502f0$@ust.hk
Whole thread Raw
Responses Re: how to improve the performance of creating index  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Re: how to improve the performance of creating index  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance

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?

All helps are appreciated.

 

Thanks.

Yinan

pgsql-performance by date:

Previous
From: ismo.tuononen@solenovo.fi
Date:
Subject: Re: How to improve speed of 3 table join &group (HUGE tables)
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: how to improve the performance of creating index