Re: Harddisk performance degrading over time?

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/

In response to

Responses

Browse pgsql-general by date

  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?