Re: TRUNCATE TABLE - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: TRUNCATE TABLE
Date
Msg-id 46B050B8.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: TRUNCATE TABLE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TRUNCATE TABLE
List pgsql-performance
>>> 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:
> 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?

-Kevin




pgsql-performance by date:

Previous
From: Adriaan van Os
Date:
Subject: Re: TRUNCATE TABLE
Next
From: "Carlos H. Reimer"
Date:
Subject: RES: Improving select peformance