Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52536=pgsql-performance-ar@postgresql.org>)
 id 1Xz2aS-0001Jz-3m
 for pgsql-performance@arkaria.postgresql.org; Thu, 11 Dec 2014 12:11:16 +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+M52536=pgsql-performance-ar@postgresql.org>)
 id 1Xz2aR-0001pZ-6K
 for pgsql-performance@arkaria.postgresql.org; Thu, 11 Dec 2014 12:11:15 +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 <itparanoia@gmail.com>)
 id 1Xz2aQ-0001pT-7K
 for pgsql-performance@postgresql.org; Thu, 11 Dec 2014 12:11:14 +0000
Received: from mail-wi0-x234.google.com ([2a00:1450:400c:c05::234])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <itparanoia@gmail.com>)
 id 1Xz2aM-00014X-ND
 for pgsql-performance@postgresql.org; Thu, 11 Dec 2014 12:11:12 +0000
Received: by mail-wi0-f180.google.com with SMTP id n3so8395258wiv.13
 for <pgsql-performance@postgresql.org>; Thu, 11 Dec 2014 04:11:08 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=content-type:mime-version:subject:from:in-reply-to:date:cc
 :content-transfer-encoding:message-id:references:to;
 bh=qUatR4VgSIlu02XczDLVz0yye0jKc5tXytnS53R+AOo=;
 b=dM2B3E+kY9aY3Zu4anoh9kon4k9JHKzxtIMOVC0muliXiq7WqN7J4XV5ZJWhzaeFnh
 jGLW8DemCDB1eGoXDYW4TeEKzlSduo2mmxF8VRzoolsDMLrSVDb2oZ1X7yvxDabmpkB4
 TkzX3vFQMPZP2XQCVgyecAFENp5j4eC6HMJNc7IcxldzFc5VC2fEuQgf4S8KE0OK9T3T
 5ndLFv7scjXDnN8cQvKuxIuKT4QxBhT0WCUGNS1S0gPhQsnSu+UD99L8MV0F1npz2Q0a
 1oj7AOJwj6G2XPz0rbSnLakfnXB8XqW49Kjj5Wr9khT2/ndwLHrTTJxS7s95atFgBu0f
 3Wkg==
X-Received: by 10.194.62.163 with SMTP id z3mr16379641wjr.74.1418299868202;
 Thu, 11 Dec 2014 04:11:08 -0800 (PST)
Received: from wgaybook.corp.wargaming.local (by1-office.wargaming.net.
 [178.172.239.242])
 by mx.google.com with ESMTPSA id ry19sm1477320wjb.3.2014.12.11.04.11.06
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Thu, 11 Dec 2014 04:11:07 -0800 (PST)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 8.0 \(1990.1\))
Subject: Re: Tuning the configuration
From: Evgeniy Shishkin <itparanoia@gmail.com>
In-Reply-To: <548987D7.7040304@opinioni.net>
Date: Thu, 11 Dec 2014 15:11:05 +0300
Cc: mfatticcioni@mbigroup.it,
 pgsql-performance@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <6B084BAC-82C6-410A-88D4-9CDC01DA8C09@gmail.com>
References: <548823F8.4070003@mbigroup.it> <548987D7.7040304@opinioni.net>
To: Andrea Suisani <sickpig@opinioni.net>
X-Mailer: Apple Mail (2.1990.1)
X-Pg-Spam-Score: -2.7 (--)
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


> On 11 Dec 2014, at 15:02, Andrea Suisani <sickpig@opinioni.net> wrote:
> 
> On 12/10/2014 11:44 AM, Maila Fatticcioni wrote:
>> 2- I would like to use the two SDD to store the wal file. Do you think
>> it is useful or how should I use them?
> 
> I definitely would give it a try.
> 


I don't understand the logic behind using drives, 
which are best for random io, for sequent io workloads.

Better use 10k sas with BBU raid for wal, money wise.



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