Re: Hardware question for a DB server - Mailing list pgsql-performance

From Greg Smith
Subject Re: Hardware question for a DB server
Date
Msg-id Pine.GSO.4.64.0803121602410.28886@westnet.com
Whole thread Raw
In response to Re: Hardware question for a DB server  (Mark Lewis <mark.lewis@mir3.com>)
Responses Re: Hardware question for a DB server
List pgsql-performance
On Wed, 12 Mar 2008, Mark Lewis wrote:

> One question that's likely going to be important depending on your
> answers above is whether or not you're getting a battery-backed write
> cache for that ServeRAID-8K.

Apparently there's a 8k-l and an regular 8-k; the l doesn't have the
cache, so if this one is a regular 8-k it will have 256MB and a battery.
See http://www.redbooks.ibm.com/abstracts/TIPS0054.html?Open#ServeRAID-8k

From Pascal's description of the application this system sounds like
overkill whether or not there's a cache.  For scaling to lots of small
requests, using things like using connection pooling may end up being more
important than worring about the disk system (the database isn't big
enough relative to RAM for that to be too important).

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Pascal Cohen
Date:
Subject: Re: Hardware question for a DB server
Next
From: "Mark Steben"
Date:
Subject: Are piped columns indexable