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

Re: hardware advice

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: "M(dot) D(dot)" <lists(at)turnkey(dot)bz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: hardware advice
Date: 2012-09-27 19:22:18
Message-ID: CAGTBQpYWepA3-su2tHDa276KSwznLSyUVGj_rquyKrtR+z9oxw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Sep 27, 2012 at 4:11 PM, M. D. <lists(at)turnkey(dot)bz> wrote:
> At this point I'm dealing with a fairly small database of 8 to 9 GB.
...
> The on_hand lookup table
> currently has 3 million rows after 4 years of data.
...
> For both servers I'd have at least 32GB Ram and 4 Hard Drives in raid 10.

For a 9GB database, that amount of RAM seams like overkill to me.
Unless you expect to grow a lot faster than you've been growing, or
perhaps your middle tier consumes a lot of those 32GB, I don't see the
point there.


In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2012-09-27 19:37:51
Subject: Re: hardware advice
Previous:From: M. D.Date: 2012-09-27 19:11:24
Subject: hardware advice

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