Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5240A9FB6EF for ; Fri, 13 Jul 2007 06:21:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96005-03 for ; Fri, 13 Jul 2007 06:21:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id F2E8D9FB5FF for ; Fri, 13 Jul 2007 06:21:08 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d32so766064pye for ; Fri, 13 Jul 2007 02:21:03 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cgV9QoR0TzJ5TMThoSlo84ltcKFfD47tTr4BuXYxaS1bhNTksvwnnMsJb0O7aDzhKuA8AOOoOmfXwhkET60nq254ltJ0ruh5+C0Rs727py4JllQmXZp0P3f6iBnHPoqDTTF7pQy6npQSw2/+In+VatqQUQ0Xkko4voXtj8IUVO0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dHcBEyfUAbg/CsCot1f26wMxGmR+9/rXLul9oKj9AMUaFbT4ou+dtvvud8j39qsA/PpDiurOe8QZ1uLvUUk9rPQ9YXEfYFHiPSf5437PhTyI1DyDj45xdYVxa5n8pcdsIuSPALtYuWGa5ekgvXqFjrscJ4QF80DBID/Uk7v2+Lc= Received: by 10.35.75.15 with SMTP id c15mr2300076pyl.1184318462409; Fri, 13 Jul 2007 02:21:02 -0700 (PDT) Received: by 10.35.91.3 with HTTP; Fri, 13 Jul 2007 02:21:02 -0700 (PDT) Message-ID: <4e96c6600707130221m2c4782d6k2d1f83b4841df832@mail.gmail.com> Date: Fri, 13 Jul 2007 11:21:02 +0200 From: "Thomas Samson" To: pgsql-performance@postgresql.org Subject: Re: TRUNCATE TABLE In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <46953949.3030201@microbizz.nl> <87ps2ypox3.fsf@oxford.xeocode.com> <46972DFA.9000900@microbizz.nl> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/149 X-Sequence-Number: 25833 On 7/13/07, Jean-Max Reymond wrote: > Adriaan van Os a =E9crit : > > That's a remarkable advice, because XFS is known to be slow at creating > > and deleting files, see and > > . > > > > date of article: Fri Jul 25 2003 ! > Even at this date, the article end with : "More interestingly, my delete performance has actually superseded that of ext3, for both random and sequential deletes! The most major weakness of XFS has been eliminated, and my spankin' new filesystem is ready to rock. Cheers!" --=20 Thomas SAMSON I came, I saw, I deleted all your files.