[To admin: this message was posted earlier via google group. needless
to say, it was stalled waiting for approval, please ignore that
one. Thanks.]
Hi,
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
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
I talked with neilc in #postgresql about a tool that may help in
determining a suitable rpc value. If rpc is just ratio of random cost
vs. sequential cost, then I can write such a tool. So I did.
The tool takes a directory and do sequential read on all the files
there, followed by exhaustive (each