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 825DDDB726 for ; Thu, 17 Nov 2005 21:50:57 -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 09259-02 for ; Fri, 18 Nov 2005 01:51:00 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from houston.familyhealth.com.au (houston.au.fhnetwork.com [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 356FFDB71D for ; Thu, 17 Nov 2005 21:50:53 -0400 (AST) Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id AD0DA25079; Fri, 18 Nov 2005 09:50:56 +0800 (WST) Received: from [127.0.0.1] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (Postfix) with ESMTP id 2877D25078; Fri, 18 Nov 2005 09:50:51 +0800 (WST) Message-ID: <437D34CC.9080200@familyhealth.com.au> Date: Fri, 18 Nov 2005 09:56:28 +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> <437C9CBE.8020907@familyhealth.com.au> <20051117172511.GA28121@uio.no> In-Reply-To: <20051117172511.GA28121@uio.no> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-familyhealth-MailScanner-Information: Please contact the ISP for more information X-familyhealth-MailScanner: Found to be clean X-familyhealth-MailScanner-From: chriskl@familyhealth.com.au X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.02 required=5 tests=[AWL=0.020] X-Spam-Score: 0.02 X-Spam-Level: X-Archive-Number: 200511/342 X-Sequence-Number: 15599 > I do not really see why all the distributions could do something like this, > instead of mucking around with special statically compiled pg_dumps and the > like... Contrib modules and tablespaces. Plus, no version of pg_dump before 8.0 is able to actually perform such reliable dumps and reloads (due to bugs). However, that's probably moot these days. Chris