Re: Hardware/OS recommendations for large databases (

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