Horton

Re: understanding postgres issues/bottlenecks

Mark Kirkwood <markir@paradise.net.nz>

View thread View on postgr.es
From: Mark Kirkwood <markir@paradise.net.nz>
To: david@lang.hm
Cc: Luke Lonergan <LLonergan@greenplum.com>, "stark@enterprisedb.com" <stark@enterprisedb.com>, "markus@bluegap.ch" <markus@bluegap.ch>, "scott.marlowe@gmail.com" <scott.marlowe@gmail.com>, "rjpeace@earthlink.net" <rjpeace@earthlink.net>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2009-01-10T23:44:16Z
Lists: pgsql-performance 
david@lang.hm wrote:
> On Sat, 10 Jan 2009, Luke Lonergan wrote:
>
>> The new MLC based SSDs have better wear leveling tech and don't 
>> suffer the pauses.  Intel X25-M 80 and 160 GB SSDs are both 
>> pause-free.  See Anandtech's test results for details.
>
> they don't suffer the pauses, but they still don't have fantasic write 
> speeds.
>
> David Lang
>
>> Intel's SLC SSDs should also be good enough but they're smaller.
>>

 From what I can see, SLC SSDs are still quite superior for reliability 
and (write) performance. However they are too small and too expensive 
right now. Hopefully the various manufacturers are working on improving 
the size/price issue for SLC, as well as improving the 
performance/reliability area for the MLC products.

regards

Mark