Home > mailing lists

SSDs with Postgresql? - Mailing list pgsql-general

From	Benjamin Smith
Subject	SSDs with Postgresql?
Date	April 14, 2011 04:32:38
Msg-id	201104132119.55264.lists@benjamindsmith.com Whole thread Raw
Responses	Re: SSDs with Postgresql? Re: SSDs with Postgresql? Re: SSDs with Postgresql?
List	pgsql-general

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?

-Ben
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

From: Tom Lane
Date: 14 April 2011, 04:06:52
Subject: Re: 9.0 Out of memory

From: Lonni J Friedman
Date: 14 April 2011, 04:52:41
Subject: Re: updating rows which have a common value forconsecutive dates