On Tue, Oct 25, 2005 at 04:37:34PM -0400, Yohanes Santoso wrote:
> > All of this goes to uphold Tom's general assertion that the default of 4 is
> > more or less correct
>
> Doesn't this show that 4:1 is a pretty optimistic value considering
> that no long-running db files are fragmentation-free
Yohanes Santoso wrote:
I then ran it on various database size on a software 2 7200RPM IDE
RAID-1 volume. I found out that if the dbase size (as from du
) is less than about 500M, I got a ratio of 4.5:1. On a
larger dbase, 3GB, the ratio increases to 10:1.
Surely this is going to be a fun
Josh Berkus writes:
>> I tested the db files residing on a software RAID-1 composed of 2 IDE
>> 7200rpm drives on linux 2.6.12.
>
> FWIW, most performance-conscious users will be using a SCSI RAID
> array.
No worry, I'm not out to squeeze every little juice from a particular
installation, which
Yohanes,
> Yesterday in #pgsql, I was talking with neilc about determining rpc
> value in a more concrete way. So I created a program that compares
> exhaustive (all blocks are eventually read) random reads with
> sequential reads. The full source is attached.
Thanks for code.
> I tested the db
