ext2 doesn't need to be defrag'ed either. You CAN, but it shouldn't need it
unless you are doing something very strange.
Ole Gjerde
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Daniel Åkerud" <zilch@home.se>
Cc: "Jason Earl" <jdearl@yahoo.com>; "PostgreSQL-general"
<pgsql-general@postgresql.org>
Sent: Sunday, June 24, 2001 10:57 PM
Subject: Re: Harddisk performance degrading over time?
> > Oh yeah,
> > vacuuming is not the problem here.
> >
> > Thanks anyway... :)
> >
> > And also, it seems that it is the indexed searches that is suffering the
> > most. The non-indexed searches is less affected. This is not only
PostgreSQL
> > but also MySQL.
>
> I know the BSD filesystems are self-defragmenting. I don't know if the
> ext2 filesystems are the same. Surely someone must know.