Re: Making the most of memory?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "mike long" <mlong(at)concursive(dot)com>
Cc: "Joshua Fielek" <jfielek(at)centriccrm(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Making the most of memory?
Date: 2008-01-23 18:44:38
Message-ID: dcc563d10801231044p1dba892r9b8bf1269395f068@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Jan 23, 2008 8:01 AM, mike long <mlong(at)concursive(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Decibel! 2008-01-23 19:02:21 Re: Vacuum and FSM page size
Previous Message Thomas Lozza 2008-01-23 18:29:16 Vacuum and FSM page size