Re: Harddisk performance degrading over time?

From: "Ole Gjerde" <gjerdelist(at)icebox(dot)org>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Harddisk performance degrading over time?
Date: 2001-06-26 12:07:41
Message-ID: 02d701c0fe38$9d5ff870$0b64a8c0@mimer.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)candle(dot)pha(dot)pa(dot)us>
To: "Daniel Åkerud" <zilch(at)home(dot)se>
Cc: "Jason Earl" <jdearl(at)yahoo(dot)com>; "PostgreSQL-general"
<pgsql-general(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joerg Hessdoerfer 2001-06-26 12:09:27 How to fill 'bytea' columns?!?
Previous Message Paul Tomblin 2001-06-26 12:00:28 Re: Red Hat to support PostgreSQL