Re: TRUNCATE TABLE

[Adriaan van Os <postgres(at)microbizz(dot)nl>]

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