Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52538=pgsql-performance-ar@postgresql.org>)
 id 1Xz3cA-0003fN-95
 for pgsql-performance@arkaria.postgresql.org; Thu, 11 Dec 2014 13:17:06 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52538=pgsql-performance-ar@postgresql.org>)
 id 1Xz3c9-0000vA-Kd
 for pgsql-performance@arkaria.postgresql.org; Thu, 11 Dec 2014 13:17:05 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <sickpig@opinioni.net>)
 id 1Xz3c8-0000v3-FA
 for pgsql-performance@postgresql.org; Thu, 11 Dec 2014 13:17:04 +0000
Received: from mx1.opinioni.net ([213.187.10.46])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sickpig@opinioni.net>) id 1Xz3c4-0002F3-FN
 for pgsql-performance@postgresql.org; Thu, 11 Dec 2014 13:17:02 +0000
Received: from localhost (localhost [127.0.0.1])
 by mx1.opinioni.net (Postfix) with ESMTP id C5EAF1CABA1;
 Thu, 11 Dec 2014 14:16:59 +0100 (CET)
Received: from mx1.opinioni.net ([127.0.0.1])
 by localhost (opinioni.net [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id Nx9LmeTsELYh; Thu, 11 Dec 2014 14:16:59 +0100 (CET)
Received: from [192.168.1.50] (78-134-6-72.v4.ngi.it [78.134.6.72])
 (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits))
 (No client certificate requested)
 by mx1.opinioni.net (Postfix) with ESMTPS id 85E156CDE;
 Thu, 11 Dec 2014 14:16:59 +0100 (CET)
Message-ID: <54899948.8070305@opinioni.net>
Date: Thu, 11 Dec 2014 14:16:56 +0100
From: Andrea Suisani <sickpig@opinioni.net>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.3.0
MIME-Version: 1.0
To: mfatticcioni@mbigroup.it, Evgeniy Shishkin <itparanoia@gmail.com>,
 Andrea Suisani <sickpig@opinioni.net>
CC: pgsql-performance@postgresql.org
Subject: Re: Tuning the configuration
References: <548823F8.4070003@mbigroup.it> <548987D7.7040304@opinioni.net>
 <6B084BAC-82C6-410A-88D4-9CDC01DA8C09@gmail.com> <54899289.40307@mbigroup.it>
In-Reply-To: <54899289.40307@mbigroup.it>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


> Would you mind to explain me better why you do suggest me to use the
> sas raid for wal please?

SSDs are known to shine when they have to deal with random access pattern
rather than sequential, on the other hand 10/15K rpm SAS disk is known to be
better for sequential io workloads (in general "rotating" disk use to be
better at sequential rather than random access)

Having said that it seems that SSDs are catching up, see:

http://www.anandtech.com/show/6935/seagate-600-ssd-review/5

Andrea


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance