From: | Daniel Åkerud <zilch(at)home(dot)se> |
---|---|
To: | "Jason Earl" <jdearl(at)yahoo(dot)com>, "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Harddisk performance degrading over time? |
Date: | 2001-06-24 14:08:55 |
Message-ID: | 000901c0fcb7$34734c40$c901a8c0@automatic100 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-06-24 17:40:41 | Re: Foreign Keys Constraints, perforamance analysis |
Previous Message | Jason Earl | 2001-06-24 14:05:25 | Re: Harddisk performance degrading over time? |