Re: Hardware/OS recommendations for large databases

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Ron" <rjpeace(at)earthlink(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware/OS recommendations for large databases
Date: 2005-11-27 19:11:53
Message-ID: BFAF44F9.14865%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ron,

On 11/27/05 9:10 AM, "Ron" <rjpeace(at)earthlink(dot)net> wrote:

> Clever use of RAM can get a 5TB sequential scan down to ~17mins.
>
> Yes, it's a lot of data. But sequential scan times should be in the
> mins or low single digit hours, not days. Particularly if you use
> RAM to maximum advantage.

Unfortunately, RAM doesn't help with scanning from disk at all.

WRT using network interfaces to help - it's interesting, but I think what
you'd want to connect to is other machines with storage on them.

- Luke

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2005-11-27 19:31:24 Re: Hardware/OS recommendations for large databases (
Previous Message Ron 2005-11-27 17:10:44 Re: Hardware/OS recommendations for large databases