Re: Re: Harddisk performance degrading over time?

OK,
so now I know it wasn't that.

The strange thing is just that, that looking at all the test values
collected, it seems like only indexed inserts and indexed selects has gotten
slower for BOTH PostgreSQL and MySQL,

Never mind... as long as it is maximally slow now ;) *kidding*

Daniel Åkerud

> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>