| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Daniel Åkerud <zilch(at)home(dot)se> |
| Cc: | Jason Earl <jdearl(at)yahoo(dot)com>, PostgreSQL-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Harddisk performance degrading over time? |
| Date: | 2001-06-24 20:57:25 |
| Message-ID: | 200106242057.f5OKvPU28352@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-24 22:29:29 | Re: Harddisk performance degrading over time? |
| Previous Message | Daniel Åkerud | 2001-06-24 20:00:08 | RE: Foreign Keys Constraints, perforamance analysis |