On Sun, 27 Nov 2005, Luke Lonergan wrote:
For data warehousing its pretty well open and shut. To use all cpus and
io channels on each query you will need mpp.
Has anyone done the math.on the original post? 5TB takes how long to
scan once? If you want to wait less than a couple of days just for a
seq scan, you'd better be in the multi-gb per second range.
if you truely need to scan the entire database then you are right, however
indexes should be able to cut the amount you need to scan drasticly.
David Lang
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly