> 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
