Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id F35849FA433 for ; Wed, 25 Oct 2006 13:14:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 28074-04 for ; Wed, 25 Oct 2006 16:14:03 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id E10C59FB1E1 for ; Wed, 25 Oct 2006 13:14:01 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id g2so374169nfe for ; Wed, 25 Oct 2006 09:14:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=gtJV/YCpDB/tW2R/ugq8JsSq4sTyzKMuvSZEGsJTtyBt9hbOeYOSxDYziiDN9As3iMyO1oHoVoRsYGi4fM0mzzJsRv13j8inwcyEBrOM6AWQmIkzZoY4GxwnltlvVbEKHIfIZDNvbAJnwdZvkwDo9oaTUIRIz4AC9GukY6T7UjE= Received: by 10.49.10.3 with SMTP id n3mr3578325nfi; Wed, 25 Oct 2006 09:13:59 -0700 (PDT) Received: by 10.49.42.19 with HTTP; Wed, 25 Oct 2006 09:13:59 -0700 (PDT) Message-ID: <38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com> Date: Wed, 25 Oct 2006 10:13:59 -0600 From: "Joshua Marsh" To: pgsql-admin@postgresql.org Subject: CLUSTER using more memory than expected MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_33935_14403092.1161792839690" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/161 X-Sequence-Number: 23464 ------=_Part_33935_14403092.1161792839690 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline The CLUSTER function seems to be using more memory than I expect. Here is what I get from top and from my config file: from top: 27589 postgres 25 0 3943m 3.6g 11m R 99.9 61.6 639:19.41 postgres: postgres data 127.0.0.1(42126) CLUSTER from postgresql.conf shared_buffers = 1000 #26214 # min 16, at least max_connections*2, 8KB each work_mem = 256000 # min 64, size in KB maintenance_work_mem = 2097151 # min 1024, size in KB #max_stack_depth = 2048 # min 100, size in KB My version is: 8.0.3 Any ideas why this would be happening. I tried a full restart and the same thing happens. Thanks, Josh -- This E-mail is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is legally privileged. This information is confidential information and is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. ------=_Part_33935_14403092.1161792839690 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline The CLUSTER function seems to be using more memory than I expect.  Here is what I get from top and from my config file:

from top:
27589 postgres  25   0 3943m 3.6g  11m R 99.9 61.6 639:19.41 postgres: postgres data 127.0.0.1(42126) CLUSTER

from postgresql.conf
shared_buffers = 1000 #26214            # min 16, at least max_connections*2, 8KB each
work_mem = 256000               # min 64, size in KB
maintenance_work_mem = 2097151  # min 1024, size in KB
#max_stack_depth = 2048         # min 100, size in KB

My version is: 8.0.3

Any ideas why this would be happening.  I tried a full restart and the same thing happens.

Thanks,

Josh


--
This E-mail is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is legally privileged.

This information is confidential information and is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. ------=_Part_33935_14403092.1161792839690--