From: Andrea Suisani <sickpig@opinioni.net>
To: Evgeniy Shishkin <itparanoia@gmail.com>
To: Andrea Suisani <sickpig@opinioni.net>
Cc: mfatticcioni@mbigroup.it
Cc: pgsql-performance@postgresql.org
Subject: Re: Tuning the configuration
Date: Thu, 11 Dec 2014 14:26:57 +0100
Message-ID: <54899BA1.50908@opinioni.net> (raw)
In-Reply-To: <6B084BAC-82C6-410A-88D4-9CDC01DA8C09@gmail.com>
References: <548823F8.4070003@mbigroup.it>
<548987D7.7040304@opinioni.net>
<6B084BAC-82C6-410A-88D4-9CDC01DA8C09@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sickpig@opinioni.net, itparanoia@gmail.com, mfatticcioni@mbigroup.it
Subject: Re: Tuning the configuration
In-Reply-To: <54899BA1.50908@opinioni.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox