| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durumdara | 2011-04-14 08:38:06 | Bug in PGSQL 9.0 with handling chr(1..255) in Win1250 context? |
| Previous Message | Henry C. | 2011-04-14 08:16:28 | Re: Replication: slave is in permanent startup 'recovery' |