Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xz3AS-0002dY-NT for pgsql-performance@arkaria.postgresql.org; Thu, 11 Dec 2014 12:48:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xz3AR-0004iv-BM for pgsql-performance@arkaria.postgresql.org; Thu, 11 Dec 2014 12:48:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xz3AQ-0004io-6s for pgsql-performance@postgresql.org; Thu, 11 Dec 2014 12:48:26 +0000 Received: from ms.mbigroup.it ([84.233.239.90]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xz3AN-00034m-Hg for pgsql-performance@postgresql.org; Thu, 11 Dec 2014 12:48:24 +0000 Received: from localhost (localhost [127.0.0.1]) by ms.mbigroup.it (Postfix) with ESMTP id 708CC1C13D3; Thu, 11 Dec 2014 13:48:10 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at ms.mbigroup.it Received: from ms.mbigroup.it ([127.0.0.1]) by localhost (ms.mbigroup.it [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LPRo-XMATXAF; Thu, 11 Dec 2014 13:48:09 +0100 (CET) Received: from mailserver0.bo.mbigroup.it (mailserver1.bo.mbigroup.it [192.168.10.31]) by ms.mbigroup.it (Postfix) with ESMTPS id BB9BE1C13B3; Thu, 11 Dec 2014 13:48:09 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mailserver0.bo.mbigroup.it (Postfix) with ESMTP id 23B192C1832; Thu, 11 Dec 2014 13:48:10 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at mbigroup.it Received: from mailserver0.bo.mbigroup.it ([127.0.0.1]) by localhost (mailserver1.bo.mbigroup.it [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Yefmuzak9pL8; Thu, 11 Dec 2014 13:48:10 +0100 (CET) Received: from [192.168.27.201] (unknown [192.168.27.201]) by mailserver0.bo.mbigroup.it (Postfix) with ESMTP id 4E8B62C1831; Thu, 11 Dec 2014 13:48:09 +0100 (CET) Message-ID: <54899289.40307@mbigroup.it> Date: Thu, 11 Dec 2014 13:48:09 +0100 From: Maila Fatticcioni Reply-To: mfatticcioni@mbigroup.it Organization: MBI S.r.l. User-Agent: Mozilla/5.0 (X11; Linux i686; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: Evgeniy Shishkin , Andrea Suisani 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> In-Reply-To: <6B084BAC-82C6-410A-88D4-9CDC01DA8C09@gmail.com> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.1 (-) 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 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/11/2014 01:11 PM, Evgeniy Shishkin wrote: > >> On 11 Dec 2014, at 15:02, Andrea Suisani >> 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. > > > Would you mind to explain me better why you do suggest me to use the sas raid for wal please? Thanks, M. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlSJkokACgkQi2q3wPb3FcOOZQCgrhy3sOP3Jds1eGlPqjSW+GhM xFIAn3YbZgEFAlwTC+SX7GG2My0pElys =Bsn7 -----END PGP SIGNATURE----- -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance