Re: TRUNCATE TABLE - Mailing list pgsql-performance

From Gregory Stark
Subject Re: TRUNCATE TABLE
Date
Msg-id 87tzs865hy.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: TRUNCATE TABLE  (Adriaan van Os <postgres@microbizz.nl>)
List pgsql-performance
"Adriaan van Os" <postgres@microbizz.nl> writes:

> 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>.

I think this is a case of "you're both right". XFS may have to do more work
than other filesystems for meta-information updates. However It still only has
to do a constant or nearly constant amount of work. So it may be slower at
managing a large directory of thousands of small files than ext3, but it's
faster at deleting a single 1G file than ext3.

On mythtv the experience is that if you use ext3 and delete a large file while
recording another program you can expect the new recording to lose stutter at
that point. The large delete will lock out the recording from writing to the
filesystem for several seconds.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: Adriaan van Os
Date:
Subject: Re: TRUNCATE TABLE
Next
From: Jean-Max Reymond
Date:
Subject: Re: TRUNCATE TABLE