Re: How to make a REALLY FAST db server?

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to make a REALLY FAST db server?
Date: 2001-09-11 04:12:37
Message-ID: 20010911041237.9438.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> As far as disks go. You cannot have too many spindles. But the number of
> spindles you have available depends on which pieces of postgres get split
> onto dedicated spindles.

But if you have enough RAM that the entire DB can be held in RAM, and
if the DB acess pattern is 90% read, 10% write (which is usually the
case) then do you really need to worry about disk performance?

It seems like for most applications, it is possible to hold all the
data in RAM, and RAM is cheap these days.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2001-09-11 04:43:06 Re: Fwd: Re: unicode in 7.1
Previous Message Hunter Hillegas 2001-09-11 03:43:04 MacOS X Build Fails with 7.1.3