Re: TRUNCATE TABLE

From: "Thomas Samson" <koollman(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: TRUNCATE TABLE
Date: 2007-07-13 09:21:02
Message-ID: 4e96c6600707130221m2c4782d6k2d1f83b4841df832@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 7/13/07, Jean-Max Reymond <jmreymond(at)gmail(dot)com> wrote:
> Adriaan van Os a écrit :
> > 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>.
> >
>
> date of article: Fri Jul 25 2003 !
>

Even at this date, the article end with :

"More interestingly, my delete performance has actually superseded
that of ext3, for
both random and sequential deletes! The most major weakness of XFS has been
eliminated, and my spankin' new filesystem is ready to rock. Cheers!"

--
Thomas SAMSON
I came, I saw, I deleted all your files.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Philippe Amelant 2007-07-13 09:56:29 Re: PostgreSQL publishes first real benchmark
Previous Message Jean-Max Reymond 2007-07-13 09:05:53 Re: TRUNCATE TABLE