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

Re: TRUNCATE TABLE

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: Adriaan van Os <postgres(at)microbizz(dot)nl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TRUNCATE TABLE
Date: 2007-07-13 12:44:38
Message-ID: 20070713124435.GL31358@mathom.us (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Jul 13, 2007 at 09:47:06AM +0200, Adriaan van Os wrote:
>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>.

xfs' slowness is proportional to the *number* rather than the *size* of 
the files. In postgres you'll tend to have fewer, larger, files than you 
would in (e.g.) a source code repository, so it is generally more 
important to have a filesystem that deletes large files quickly than a 
filesystem that deletes lots of files quickly. I'd suspect that the same 
is true for mythtv.

Mike Stone

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2007-07-13 14:40:30
Subject: Re: TRUNCATE TABLE
Previous:From: Ray StellDate: 2007-07-13 12:08:13
Subject: Re: PostgreSQL publishes first real benchmark

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