Re: Harddisk performance degrading over time? - Mailing list pgsql-general

From Jason Earl
Subject Re: Harddisk performance degrading over time?
Date
Msg-id 20010624140525.11876.qmail@web10005.mail.yahoo.com
Whole thread Raw
In response to Harddisk performance degrading over time?  (Daniel Åkerud <zilch@home.se>)
List 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@home.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/

pgsql-general by date:

Previous
From: Daniel Åkerud
Date:
Subject: Harddisk performance degrading over time?
Next
From: Daniel Åkerud
Date:
Subject: Re: Harddisk performance degrading over time?