From: | Eric Pierce <epierce(at)saasmadeeasy(dot)com> |
---|---|
To: | Evgeniy Shishkin <itparanoia(at)gmail(dot)com>, Andrea Suisani <sickpig(at)opinioni(dot)net> |
Cc: | "mfatticcioni(at)mbigroup(dot)it" <mfatticcioni(at)mbigroup(dot)it>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Tuning the configuration |
Date: | 2014-12-11 22:36:51 |
Message-ID: | cf0230bc733d4f9aa7d7d0d35e2ffa4f@H-EX-01.hosting.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
________________________________________
From: pgsql-performance-owner(at)postgresql(dot)org <pgsql-performance-owner(at)postgresql(dot)org> on behalf of Evgeniy Shishkin <itparanoia(at)gmail(dot)com>
Sent: Thursday, December 11, 2014 7:11 AM
To: Andrea Suisani
Cc: mfatticcioni(at)mbigroup(dot)it; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Tuning the configuration
> On 11 Dec 2014, at 15:02, Andrea Suisani <sickpig(at)opinioni(dot)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.
Very much agree with this. Because SSD is fast doesn't make it suited for certain things, and a streaming sequential 100% write workload is one of them. I've worked with everything from local disk to high-end SAN and even at the high end we've always put any DB logs on spinning disk. RAID1 is generally sufficient. SSD is king for read heavy random I/O workload.
--
Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2014-12-12 00:04:19 | Re: Tuning the configuration |
Previous Message | Andrea Suisani | 2014-12-11 13:26:57 | Re: Tuning the configuration |