Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7CB8B9FA228 for ; Fri, 19 Oct 2007 08:57:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16574-02 for ; Fri, 19 Oct 2007 08:57:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cse.ust.hk (cssvr7.cse.ust.hk [143.89.41.157]) by postgresql.org (Postfix) with ESMTP id 80C1F9FA1FE for ; Fri, 19 Oct 2007 08:57:36 -0300 (ADT) Received: from LENOVO098A0F97 (laptopgw.cse.ust.hk [143.89.41.237]) (authenticated bits=0) by cse.ust.hk (8.13.8/8.12.5) with ESMTP id l9JBvVf5012512 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Fri, 19 Oct 2007 19:57:32 +0800 From: "Yinan Li" To: Subject: how to improve the performance of creating index Date: Fri, 19 Oct 2007 19:57:32 +0800 Message-ID: <01c601c81247$3b8c5650$b2a502f0$@ust.hk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01C7_01C8128A.49AF9650" X-Mailer: Microsoft Office Outlook 12.0 thread-index: AcgSRznM3HsjLlQjT6aBDpbv7gtVeA== Content-Language: zh-cn X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/226 X-Sequence-Number: 27248 UbJGR;7b MIME 8qJ=5D6`2?7VSJ<~!# ------=_NextPart_000_01C7_01C8128A.49AF9650 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_01C7_01C8128A.49AF9650 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hi, all

 

  &n= bsp;      I am trying to improve the performance of creating = index.

  &n= bsp;      I’ve set shared_buffers =3D 1024MB

  &n= bsp;           &nb= sp;    Effective_cache_size =3D 1024MB

  &n= bsp;           &nb= sp;    Work_mem =3D 1GB

  &n= bsp;           &nb= sp;    Maintenance_work_mem=3D512MB

  &n= bsp;      (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

------=_NextPart_000_01C7_01C8128A.49AF9650--