Skip site navigation (1) Skip section navigation (2)

Re: Hardware/OS recommendations for large databases (

From: David Lang <dlang(at)invendra(dot)net>
To: Luke Lonergan <LLonergan(at)greenplum(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-26 19:34:14
Message-ID: Pine.LNX.4.62.0511261129040.2790@qnivq.ynat.uz (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Luke LonerganDate: 2005-11-26 20:15:28
Subject: Re: Open request for benchmarking input
Previous:From: Qingqing ZhouDate: 2005-11-26 18:57:47
Subject: Re: Open request for benchmarking input

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group