[HACKERS] determining random_page_cost value

2005-10-25 Thread Yohanes Santoso
[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

Re: [HACKERS] determining random_page_cost value

2005-10-25 Thread Yohanes Santoso
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

[HACKERS] Determining random_page_cost value

2005-10-26 Thread Yohanes Santoso
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