Re: Hardware question for a DB server

From: Pascal Cohen <pcohen(at)wimba(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware question for a DB server
Date: 2008-03-14 19:24:25
Message-ID: 47DAD0E9.2090500@wimba.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith wrote:
> 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
It is the solution with RAM and battery.
>
>> 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).
>
I agree with what you are saying. We are using Java with a pool of
connections to access the DB. Today our database is really small
compared to the RAM but it may evolve and even will probably grow (hope
so which would be a good situation).

Thanks for your advices/remarks.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-03-14 19:43:33 Re: Hardware question for a DB server
Previous Message Oleg Bartunov 2008-03-14 18:59:05 Re: The "many nulls" problem