Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: Harddisk performance degrading over time?
Date
Msg-id 200106242057.f5OKvPU28352@candle.pha.pa.us
Whole thread Raw
In response to Re: Harddisk performance degrading over time?  (Daniel Åkerud <zilch@home.se>)
Responses Re: Harddisk performance degrading over time?  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
Tree view 
> 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.

I know the BSD filesystems are self-defragmenting.  I don't know if the
ext2 filesystems are the same.  Surely someone must know.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Jose Manuel Lorenzo Lopez
Date:
Subject: strange behavior using foreign keys
Next
From: Daniel Åkerud
Date:
Subject: RE: Foreign Keys Constraints, perforamance analysis