Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 94A489FBA8B for ; Fri, 13 Jul 2007 06:05:42 -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 93522-07 for ; Fri, 13 Jul 2007 06:05:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id C35679FB395 for ; Fri, 13 Jul 2007 06:05:39 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 19340341A0; Fri, 13 Jul 2007 11:05:33 +0200 (MET DST) From: Jean-Max Reymond X-Newsgroups: pgsql.performance Subject: Re: TRUNCATE TABLE Date: Fri, 13 Jul 2007 11:05:53 +0200 Organization: Hub.Org Networking Services Lines: 7 Message-ID: References: <46953949.3030201@microbizz.nl> <87ps2ypox3.fsf@oxford.xeocode.com> <46972DFA.9000900@microbizz.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5.0.12 (X11/20070604) In-Reply-To: <46972DFA.9000900@microbizz.nl> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/148 X-Sequence-Number: 25832 Adriaan van Os a écrit : > 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 !