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

how to improve the performance of creating index

From: "Yinan Li" <yinanli(at)cse(dot)ust(dot)hk>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: how to improve the performance of creating index
Date: 2007-10-19 11:57:32
Message-ID: 01c601c81247$3b8c5650$b2a502f0$@ust.hk (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2007-10-19 12:03:27
Subject: Re: how to improve the performance of creating index
Previous:From: ismo.tuononenDate: 2007-10-19 04:40:17
Subject: Re: How to improve speed of 3 table join &group (HUGE tables)

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