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

Re: SSDs with Postgresql?

From: "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za>
To: "Benjamin Smith" <lists(at)benjamindsmith(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SSDs with Postgresql?
Date: 2011-04-14 08:35:03
Message-ID: (view raw or whole thread)
Lists: pgsql-general
On Thu, April 14, 2011 06:19, Benjamin Smith wrote:
> The speed benefits of SSDs as benchmarked would seem incredible. Can anybody
> comment on SSD benefits and problems in real life use?
> I maintain some 100 databases on 3 servers, with 32 GB of RAM each and an
> extremely rich, complex schema. (300+ normalized tables)
> I was wondering if anybody here could comment on the benefits of SSD in
> similar, high-demand rich schema situations?

Even if you only use SSDs for your indexes, the gains are staggering.  We use
them on several servers, one of which is extremely busy (xid wraparound stuff)
and the performance gains are game-changing.

There is no going back.  Hint: don't use cheap SSDs - cough up and use Intel.


In response to


pgsql-general by date

Next:From: DurumdaraDate: 2011-04-14 08:38:06
Subject: Bug in PGSQL 9.0 with handling chr(1..255) in Win1250 context?
Previous:From: Henry C.Date: 2011-04-14 08:16:28
Subject: Re: Replication: slave is in permanent startup 'recovery'

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