Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 65D7A9FB88D for ; Sat, 4 Aug 2007 18:39:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65845-09 for ; Sat, 4 Aug 2007 18:39:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp.nlhosting.nl (smtp.nlhosting.nl [213.132.200.215]) by postgresql.org (Postfix) with ESMTP id C13099FB82F for ; Sat, 4 Aug 2007 18:39:32 -0300 (ADT) Received: from [192.168.1.11] ([213.132.214.93]) by smtp.nlhosting.nl (Merak 7.5.2) with ESMTP id JHA74393 for ; Sat, 04 Aug 2007 23:39:31 +0200 Message-ID: <46B4F213.3000203@microbizz.nl> Date: Sat, 04 Aug 2007 23:39:31 +0200 From: Adriaan van Os User-Agent: Thunderbird 1.5.0.4 (Macintosh/20060516) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: TRUNCATE TABLE References: <46953949.3030201@microbizz.nl> <87ps2ypox3.fsf@oxford.xeocode.com> <46972DFA.9000900@microbizz.nl> <20070713124435.GL31358@mathom.us> <21495.1184337630@sss.pgh.pa.us> <4697A58E.8060904@microbizz.nl> <23092.1184344246@sss.pgh.pa.us> <20070713173501.GD12109@alvh.no-ip.org> <162867790707131212g17cbc5a9q5d098dbf01c8e502@mail.gmail.com> <20070716213944.GA39272@nasby.net><20070716213944.GA39272@nasby.net> <25418.1184631498@sss.pgh.pa.us> <46B050B8.EE98.0025.0@wicourts.gov> In-Reply-To: <46B050B8.EE98.0025.0@wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/33 X-Sequence-Number: 26163 Kevin Grittner wrote: >>>> On Mon, Jul 16, 2007 at 7:18 PM, in message <25418.1184631498@sss.pgh.pa.us>, > Tom Lane wrote: >> Somehow, autovac is doing something that makes the filesystem go nuts >> every so often, and take an astonishingly long time to create an empty >> file. But autovac itself doesn't create or delete any files, so what's >> up here? > > Have you ruled out checkpoints as the culprit? That's a good question. I will do some more tests, but I also suspect fsync "cascading" . Regards, Adriaan van Os