Message-ID: <54899BA1.50908@opinioni.net>
Date: Thu, 11 Dec 2014 14:26:57 +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: Evgeniy Shishkin <itparanoia@gmail.com>,
 Andrea Suisani <sickpig@opinioni.net>
CC: mfatticcioni@mbigroup.it, 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; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 12/11/2014 01:11 PM, Evgeniy Shishkin wrote:
>
>> 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.

Well since Malia had already used the 4 sas hd for the DB,
I thought that it'd be quite quick to setup a raid1 array
(even at software level, e.g. using md), placing pg_xlog
in such array and measure the performance.

As a following step, depending on the time constraints involved,
Malia could rearrange the disk setup enterly and use the SAS
disks as location for pg_xlog.


Andrea


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