Re: Making the most of memory? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Making the most of memory?
Date
Msg-id dcc563d10801231044p1dba892r9b8bf1269395f068@mail.gmail.com
Whole thread Raw
In response to Making the most of memory?  (Joshua Fielek <jfielek@centriccrm.com>)
Responses Re: Making the most of memory?
List pgsql-performance
On Jan 23, 2008 8:01 AM, mike long <mlong@concursive.com> wrote:
> Scott,
>
> What are your thoughts on using one of those big RAM appliances for
> storing a Postgres database?

I assume you're talking about solid state drives?  They have their
uses, but for most use cases, having plenty of RAM in your server will
be a better way to spend your money.  For certain high throughput,
relatively small databases (i.e. transactional work) the SSD can be
quite useful.  For large reporting databases running into the terabyte
range they're prohibitively expensive.

pgsql-performance by date:

Previous
From: "Thomas Lozza"
Date:
Subject: Vacuum and FSM page size
Next
From: Rich
Date:
Subject: Re: Making the most of memory?