Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UFngP-0007i1-B6 for pgsql-performance@arkaria.postgresql.org; Wed, 13 Mar 2013 15:33:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UFngO-0002eo-P0 for pgsql-performance@arkaria.postgresql.org; Wed, 13 Mar 2013 15:33:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UFngN-0002dp-F7 for pgsql-performance@postgresql.org; Wed, 13 Mar 2013 15:33:35 +0000 Received: from out1.ip07ir2.opaltelecom.net ([62.24.128.243]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UFngL-0001kw-U8 for pgsql-performance@postgresql.org; Wed, 13 Mar 2013 15:33:34 +0000 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApQBAM+bQFFPS0Pf/2dsb2JhbAANNoghuXeCZYFtgx4BAQEBAyMVQAEQCw4KAgIFFgsCAgkDAgECAUUGDQEHAQG3DHGSWoEjjDOBNweCLYETA6pWgWo X-IronPort-AV: E=Sophos;i="4.84,837,1355097600"; d="scan'208";a="65563555" Received: from 79-75-67-223.dynamic.dsl.as9105.com (HELO [192.168.6.29]) ([79.75.67.223]) by out1.ip07ir2.opaltelecom.net with ESMTP; 13 Mar 2013 15:33:32 +0000 Message-ID: <51409C51.1070601@kickstone.com> Date: Wed, 13 Mar 2013 15:33:37 +0000 From: John Lister User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130307 Thunderbird/17.0.4 MIME-Version: 1.0 To: Gregg Jaskiewicz CC: postgres performance list Subject: Re: New server setup References: <4D6D1410-2208-4DAA-BD64-69BE1FD94E55@autouncle.com> <513CADB7.4030803@2ndQuadrant.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 12/03/2013 21:41, Gregg Jaskiewicz wrote: > > Whilst on the hardware subject, someone mentioned throwing ssd into > the mix. I.e. combining spinning HDs with SSD, apparently some raid > cards can use small-ish (80GB+) SSDs as external caches. Any > experiences with that ? > The new LSI/Dell cards do this (eg H710 as mentioned in an earlier post). It is easy to set up and supported it seems on all versions of dells cards even if the docs say it isn't. Works well with the limited testing I did, switched to pretty much all SSDs drives in my current setup These cards also supposedly support enhanced performance with just SSDs (CTIO) by playing with the cache settings, but to be honest I haven't noticed any difference and I'm not entirely sure it is enabled as there is no indication that CTIO is actually enabled and working. John -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance