X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 49C24DB951; Thu, 17 Nov 2005 11:05:15 -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 48368-08; Thu, 17 Nov 2005 15:05:18 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- 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 3645FDB975; Thu, 17 Nov 2005 11:05:11 -0400 (AST) Received: from vscan03.westnet.com.au (vscan03.westnet.com.au [203.10.1.142]) by svr2.postgresql.org (Postfix) with ESMTP id 8F2B3F0BEC; Thu, 17 Nov 2005 15:05:15 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 315CCB60294; Thu, 17 Nov 2005 23:05:11 +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 03875-07-2; Thu, 17 Nov 2005 23:05:11 +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 81F04B60280; Thu, 17 Nov 2005 23:05:10 +0800 (WST) Message-ID: <437C9C26.309@familyhealth.com.au> Date: Thu, 17 Nov 2005 23:05:10 +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: Magnus Hagander Cc: Simon Riggs , pgsql-www@postgresql.org, Tom Lane , Steve Wampler , Postgres-performance Subject: Re: [PERFORM] Help speeding up delete References: <6BCB9D8A16AC4241919521715F4D8BCE6C7BF2@algol.sollentuna.se> In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE6C7BF2@algol.sollentuna.se> Content-Type: text/plain; charset=ISO-8859-1; 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/112 X-Sequence-Number: 8827 >>That way if someone wanted to upgrade from 7.2 to 8.1, they >>can just grab the latest dumper from the website, dump their >>old database, then upgrade easily. > > But if they're upgrading to 8.1, don't they already have the new > pg_dump? How else are they going to dump their *new* database? Erm. Usually when you install the new package/port for 8.1, you cannot have both new and old installed at the same time man. Remember they both store exactly the same binary files in exactly the same place. >>In my experience not many pgsql admins have test servers or >>the skills to build up test machines with the latest pg_dump, > > I don't, but I still dump with the latest version - works fine both on > linux and windows for me... So you're saying you DO have the skills to do it then... >>etc. (Seriously.) In fact, few realise at all that they >>should use the 8.1 dumper. > > That most people don't know they should use the new one I understand > though. But I don't see how this will help against that :-) It'll make it easy... Chris