| From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Daniel Åkerud <zilch(at)home(dot)se>, 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 22:33:51 |
| Message-ID: | Pine.BSO.4.10.10106241825330.9446-100000@spider.pilosoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 24 Jun 2001, Bruce Momjian wrote:
> > 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.
Not exactly, BSD ffs (fast filesystem) isn't self-defragmenting, it just
fragments differently [less than] ext2 :)
See this for paper and some tools to get ffs fragmentation stats:
http://www.eecs.harvard.edu/~margo/usenix.195
(it has links to critique of the paper as well)
There's a tool ftp://ftp.uk.linux.org/pub/linux/sct/defrag/ to defrag ext2
filesystem, but its considered to be alpha quality and not really
maintained.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-06-24 22:49:24 | Re: Foreign Keys Constraints, perforamance analysis |
| Previous Message | Bruce Momjian | 2001-06-24 22:29:29 | Re: Harddisk performance degrading over time? |