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: 8b80298d9d78e9f3da384cca030949b4.squirrel@zenmail.co.za (view raw or flat)
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.

Cheers
Henry


In response to

Responses

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-2014 The PostgreSQL Global Development Group