Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B8D9C9FB324
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  1 Aug 2007 11:22:18 -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 54930-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  1 Aug 2007 11:22:15 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 787679FB2B8
	for <pgsql-performance@postgresql.org>;
	Wed,  1 Aug 2007 11:22:15 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Wed, 01 Aug 2007 09:22:13 -0500
Message-Id: <46B050B8.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Wed, 01 Aug 2007 09:22:00 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Jim C. Nasby" <decibel@decibel.org>,
	"Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Alvaro Herrera" <alvherre@commandprompt.com>,
	"Pavel Stehule" <pavel.stehule@gmail.com>,
	"Adriaan van Os" <postgres@microbizz.nl>,
	<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>
In-Reply-To: <25418.1184631498@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/3
X-Sequence-Number: 26133

>>> On Mon, Jul 16, 2007 at  7:18 PM, in message <25418.1184631498@sss.pgh.=
pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:=20
> 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?
=20
Have you ruled out checkpoints as the culprit?
=20
-Kevin
=20