I am trying to improve the performance of creating index.
I've set shared_buffers = 1024MB
Effective_cache_size = 1024MB
Work_mem = 1GB
(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.
pgsql-performance by date
|Next:||From: Heikki Linnakangas||Date: 2007-10-19 12:03:27|
|Subject: Re: how to improve the performance of creating index|
|Previous:||From: ismo.tuononen||Date: 2007-10-19 04:40:17|
|Subject: Re: How to improve speed of 3 table join &group (HUGE