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 по дате отправления: