Re: [PERFORM] help tuning queries on large database

2006-01-09 Thread peter royal
On Jan 9, 2006, at 2:01 PM, Luke Lonergan wrote: Peter, On 1/9/06 9:23 AM, "peter royal" <[EMAIL PROTECTED]> wrote: This is a 2-disk RAID0 Your 2-disk results look fine - what about your 8-disk results? after some further research the 2-disk RAID0 numbers are not bad.

Re: [PERFORM] help tuning queries on large database

2006-01-09 Thread peter royal
On Jan 8, 2006, at 1:42 PM, Luke Lonergan wrote: Have you tested the underlying filesystem for it's performance? Run this: time bash -c 'dd if=/dev/zero of=/my_file_system/bigfile bs=8k count= && sync' This is a 2-disk RAID0 [EMAIL PROTECTED] /opt/alt-2]# time bash -c 'dd if=/dev/zero of=

[PERFORM] help tuning queries on large database

2006-01-06 Thread peter royal
Howdy. I'm running into scaling problems when testing with a 16gb (data +indexes) database. I can run a query, and it returns in a few seconds. If I run it again, it returns in a few milliseconds. I realize this is because during subsequent runs, the necessary disk pages have been cached b