Re: TRUNCATE TABLE

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Adriaan van Os" <postgres(at)microbizz(dot)nl>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: TRUNCATE TABLE
Date: 2007-08-01 14:22:00
Message-ID: 46B050B8.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> On Mon, Jul 16, 2007 at 7:18 PM, in message <25418(dot)1184631498(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2007-08-01 15:11:39 Re: TRUNCATE TABLE
Previous Message Adriaan van Os 2007-08-01 08:27:10 Re: TRUNCATE TABLE