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 AB84CD6FF4 for ; Thu, 17 Nov 2005 07:19: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 19851-05 for ; Thu, 17 Nov 2005 11:19:59 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by svr1.postgresql.org (Postfix) with ESMTP id AA155D6853 for ; Thu, 17 Nov 2005 07:19:53 -0400 (AST) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1Echo2-0000hf-PJ for pgsql-performance@postgresql.org; Thu, 17 Nov 2005 12:19:56 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1Echnb-0006uH-00 for ; Thu, 17 Nov 2005 12:19:27 +0100 Date: Thu, 17 Nov 2005 12:19:27 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: Help speeding up delete Message-ID: <20051117111927.GB26459@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <43790A99.9050603@noao.edu> <4162.1132011763@sss.pgh.pa.us> <1132171206.4959.60.camel@localhost.localdomain> <437BDF9A.4060700@familyhealth.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <437BDF9A.4060700@familyhealth.com.au> X-Operating-System: Linux 2.6.14 on a i686 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.11 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/313 X-Sequence-Number: 15570 On Thu, Nov 17, 2005 at 09:40:42AM +0800, Christopher Kings-Lynne wrote: > In my experience not many pgsql admins have test servers or the skills > to build up test machines with the latest pg_dump, etc. (Seriously.) > In fact, few realise at all that they should use the 8.1 dumper. Isn't your distribution supposed to do this for you? Mine does these days... /* Steinar */ -- Homepage: http://www.sesse.net/