Re: TRUNCATE TABLE

From: Adriaan van Os <postgres(at)microbizz(dot)nl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: TRUNCATE TABLE
Date: 2007-08-04 21:39:31
Message-ID: 46B4F213.3000203@microbizz.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Kevin Grittner wrote:
>>>> 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?

That's a good question. I will do some more tests, but I also suspect fsync "cascading"
<http://www.uwsg.iu.edu/hypermail/linux/kernel/0708.0/1435.html>.

Regards,

Adriaan van Os

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-08-05 16:07:35 Re: Performance problems with large telemetric datasets on 7.4.2
Previous Message Ted Jordan 2007-08-04 20:35:59 Default Performance between 8.0 and 8.1