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

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: (view raw, whole thread or download thread mbox)
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


pgsql-performance by date

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

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