From: | Jason Earl <jdearl(at)yahoo(dot)com> |
---|---|
To: | "Daniel_kerud" <zilch(at)home(dot)se>, PostgreSQL-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Harddisk performance degrading over time? |
Date: | 2001-06-24 14:05:25 |
Message-ID: | 20010624140525.11876.qmail@web10005.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Daniel Åkerud | 2001-06-24 14:08:55 | Re: Harddisk performance degrading over time? |
Previous Message | Micah Yoder | 2001-06-24 04:57:48 | Bug list? |