| 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: | Whole Thread | Raw Message | 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? |