X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B310CD710A for ; Thu, 25 Aug 2005 16:13:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71816-03 for ; Thu, 25 Aug 2005 19:13:17 +0000 (GMT) Received: from pillette.com (adsl-67-119-5-202.dsl.snfc21.pacbell.net [67.119.5.202]) by svr1.postgresql.org (Postfix) with ESMTP id 8C304D7142 for ; Thu, 25 Aug 2005 16:13:15 -0300 (ADT) Received: from [192.168.1.213] (dhcp213.pillette.com [192.168.1.213] (may be forged)) by pillette.com (8.11.6/8.11.6) with ESMTP id j7PJDFu21089 for ; Thu, 25 Aug 2005 12:13:15 -0700 Message-ID: <430E1AF6.9030803@pillette.com> Date: Thu, 25 Aug 2005 12:24:38 -0700 From: Andrew Lazarus Reply-To: andrew@pillette.com Organization: Pillette Investment Management User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: What *_mem to increase when running CLUSTER References: <6EE64EF3AB31D5448D0007DD34EEB3417DD1D2@Herge.rcsinc.local> In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD1D2@Herge.rcsinc.local> Content-Type: multipart/mixed; boundary="------------050003000907070802050103" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.112 required=5 tests=[AWL=0.062, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/420 X-Sequence-Number: 14167 This is a multi-part message in MIME format. --------------050003000907070802050103 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Should I temporarily increase sort_mem, vacuum_mem, neither, or both when doing a CLUSTER on a large (100 million row) table where as many as half of the tuples are deadwood from UPDATEs or DELETEs? I have large batch (10 million row) inserts, updates, and deletes so I'm not sure frequent vacuuming would help. --------------050003000907070802050103 Content-Type: text/x-vcard; charset=utf-8; name="andrew.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="andrew.vcf" begin:vcard fn:Andrew Lazarus n:Lazarus;Andrew org:Pillette Investment Management;Research and Development adr;dom:;;3028 Fillmore;San Francisco;CA;94123 email;internet:andrew@pillette.com title:Director tel;work:800-366-0688 tel;fax:415-440-4093 url:http://www.pillette.com version:2.1 end:vcard --------------050003000907070802050103--