Re: TRUNCATE TABLE - Mailing list pgsql-performance

From Adriaan van Os
Subject Re: TRUNCATE TABLE
Date
Msg-id 46972DFA.9000900@microbizz.nl
Whole thread Raw
In response to Re: TRUNCATE TABLE  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: TRUNCATE TABLE  (Gregory Stark <stark@enterprisedb.com>)
Re: TRUNCATE TABLE  (Jean-Max Reymond <jmreymond@gmail.com>)
Re: TRUNCATE TABLE  (Michael Stone <mstone+postgres@mathom.us>)
List 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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: TRUNCATE TABLE
Next
From: Gregory Stark
Date:
Subject: Re: TRUNCATE TABLE