Skip site navigation (1) Skip section navigation (2)

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-07-13 07:47:06
Message-ID: 46972DFA.9000900@microbizz.nl (view raw or flat)
Thread:
Lists: pgsql-performance
Gregory Stark wrote:
> What filesystem is this?

Ext3 on Fedora Linux.

> Some filesystems are notoriously slow at deleting
> large files. The mythtv folk who face this problem regularly recommend either
> JFS or XFS for this purpose.

That's a remarkable advice, because XFS is known to be slow at creating and deleting files, see 
<http://en.wikipedia.org/wiki/XFS> and <http://everything2.com/index.pl?node_id=1479435>.

Regards,

Adriaan van Os


In response to

Responses

pgsql-performance by date

Next:From: Gregory StarkDate: 2007-07-13 09:02:33
Subject: Re: TRUNCATE TABLE
Previous:From: Tom LaneDate: 2007-07-12 19:20:02
Subject: Re: TRUNCATE TABLE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group