how to improve the performance of creating index

Поиск
Список
Период
Сортировка
От Yinan Li
Тема how to improve the performance of creating index
Дата
Msg-id 01c601c81247$3b8c5650$b2a502f0$@ust.hk
обсуждение исходный текст
Ответы Re: how to improve the performance of creating index
Re: how to improve the performance of creating index
Список 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 по дате отправления:

Предыдущее
От: ismo.tuononen@solenovo.fi
Дата:
Сообщение: Re: How to improve speed of 3 table join &group (HUGE tables)
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: how to improve the performance of creating index