On Thu, Mar 22, 2007 at 07:24:38PM +0100, Dimitri wrote:
you're right until you're using a single disk :) Now, imagine you have more disks

I do have more disks. I maximize the I/O performance by dedicating different sets of disks to different tables. YMMV. I do suggest watching your I/O rates and wallclock time if you try this to see if your aggregate is actually substantially faster than the single case. (I assume that you haven't yet gotten far enough to actually do performance testing.) You may also want to look into tuning your sequential I/O performance.

Mike Stone

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to