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 0F4B4D963C for ; Thu, 17 Nov 2005 11:07:44 -0400 (AST) 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 47569-09 for ; Thu, 17 Nov 2005 15:07:47 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 879ADD6853 for ; Thu, 17 Nov 2005 11:07:41 -0400 (AST) Received: from vscan03.westnet.com.au (vscan03.westnet.com.au [203.10.1.142]) by svr2.postgresql.org (Postfix) with ESMTP id 15DD8F0BF8 for ; Thu, 17 Nov 2005 15:07:45 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 28560B60184; Thu, 17 Nov 2005 23:07:43 +0800 (WST) Received: from vscan03.westnet.com.au ([127.0.0.1]) by localhost (vscan03.westnet.com.au [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04578-05-2; Thu, 17 Nov 2005 23:07:43 +0800 (WST) Received: from [202.72.133.22] (dsl-202-72-133-22.wa.westnet.com.au [202.72.133.22]) by vscan03.westnet.com.au (Postfix) with ESMTP id D140EB603EE; Thu, 17 Nov 2005 23:07:41 +0800 (WST) Message-ID: <437C9CBE.8020907@familyhealth.com.au> Date: Thu, 17 Nov 2005 23:07:42 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Steinar H. Gunderson" Cc: pgsql-performance@postgresql.org Subject: Re: Help speeding up delete References: <43790A99.9050603@noao.edu> <4162.1132011763@sss.pgh.pa.us> <1132171206.4959.60.camel@localhost.localdomain> <437BDF9A.4060700@familyhealth.com.au> <20051117111927.GB26459@uio.no> In-Reply-To: <20051117111927.GB26459@uio.no> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/317 X-Sequence-Number: 15574 > Isn't your distribution supposed to do this for you? Mine does these days... A distribution that tries to automatically do a major postgresql update is doomed to fail - spectacularly... Chris