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.

The database is totally restored each test run.

Daniel Åkerud

>
> Actually, the culprit is probably PostgreSQL and not
> the ext2 file system. Have you tried vacuuming you
> database and running the benchmarks again? PostgreSQL
> uses a non-overwriting storage manager, and so vacuum
> needs to be run periodically to clear out expired
> tuples.
>
> Jason
>
> --- Daniel_Åkerud <zilch(at)home(dot)se> wrote:
> > Do the hard disk degrade in performance over time on
> > a Linux ext2 filesystem? All my performance test
> > programs show 20% worse performance and I have done
> > NADA! I just ran them again :(
> >
> > Do you have to defrag?
> >
> > ---
> > Daniel Åkerud
> >
> > [ Don't underestimate the power of stupid people in
> > large groups]
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>