From: | david(at)lang(dot)hm |
---|---|
To: | Karl Denninger <karl(at)denninger(dot)net> |
Cc: | Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Best suiting OS |
Date: | 2009-10-06 18:15:40 |
Message-ID: | alpine.DEB.2.00.0910061114310.11706@asgard.lang.hm |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, 6 Oct 2009, Karl Denninger wrote:
> Axel Rau wrote:
>>
>> Am 05.10.2009 um 23:44 schrieb Karl Denninger:
>>
>>> Turn on softupdates. Fsck is deferred and the system comes up almost
>>> instantly even with TB-sized partitions; the fsck then cleans up the
>>> cruft.
>> Last time, I checked, there was a issue with background-fsck.
>> I will give it a chance with my new 8.0 box.
>> Do you have any experience with SSDs w/o BBUed Raidcontroller?
>> Are they fast enough to ensure flash write out of drive cache at power
>> failure after fsync ack?
>>
>> Axel
>> ---
>> axel(dot)rau(at)chaos1(dot)de PGP-Key:29E99DD6 +49 151 2300 9283 computing @
>> chaos claudius
> IMHO use the right tools for the job. In a DBMS environment where data
> integrity is "the deal" this means a BBU'd RAID adapter.
>
> SSDs have their own set of issues, at least at present..... For data
> that is read-only (or nearly-so) and of size where it can fit on a SSD
> they can provide VERY significant performance benefits, in that there is
> no seek or latency delay. However, any write-significant application is
> IMHO still better-suited to rotating media at present. This will change
> I'm sure, but it is what it is as of this point in time.
this depends on what SSD you use. for most of them you are correct, but
there are some that have very good write performance.
David Lang
Attachment | Content-Type | Size |
---|---|---|
karl.vcf | text/x-vcard | 124 bytes |
unknown_filename | text/plain | 2.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-10-06 19:28:59 | Re: Speed / Server |
Previous Message | Craig James | 2009-10-06 15:57:51 | Re: updating a row in a table with only one row |