Numbers being run on a BSD box now... FreeBSD 4.3-p27 512MB RAM 2xPiii600 Xeon ona 4 disk RAID 5 ARRAY on a dedicated ICP Vortex card. Sorry no single drives on this box, I have an outboard Silicon Gear Mercury on a motherboard based Adaptec controller I can test as well. I'll post when the tests on the Vortex are done. I'm using 2Gb files ATM, I'll look at the code and see if it can be made to work with large files. Atleast for FreeBSD the change will be mostly taking doing s/fseek/fseeko/g s/size_t/off_t/g or something similar. FreeBSD seems ot prefer teh Open Unix standard in this regard...
This will make it usable for much larger test files. Tom Lane wrote: >Michael Loftis <[EMAIL PROTECTED]> writes: > >>Somethings wrong with the random numbers from the sun... re-run them, >>that first sample is insane.... Caching looks like it's affecctign your >>results alot... >> > >Yeah; it looks like the test case is not large enough to swamp out >caching effects on the Sun box. It is on the Linux box, evidently, >since the 10:1 ratio appears very repeatable. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
