Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread david
On Wed, 24 Aug 2011, Tomas Vondra wrote: On 24 Srpen 2011, 21:42, gnuo...@rcn.com wrote: My point. The firmware and MS have been faster to support TRIM than *nix, linux in particular. Those that won't/can't move to a recent kernel don't get TRIM. Faster? Windows 7 was released on October

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread Tomas Vondra
On 24 Srpen 2011, 21:42, gnuo...@rcn.com wrote: > > > Original message >>Date: Wed, 24 Aug 2011 21:32:16 +0200 >>From: pgsql-performance-ow...@postgresql.org (on behalf of "Tomas Vondra" >> ) >>Subject: Re: [PERFORM] Reports from SSD

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread Tomas Vondra
On 24 Srpen 2011, 21:41, Merlin Moncure wrote: > On Wed, Aug 24, 2011 at 2:32 PM, Tomas Vondra wrote: >> On 24 Srpen 2011, 20:48, gnuo...@rcn.com wrote: >>> Also, given that PG is *nix centric and support for TRIM is win >>> centric, >>> having that makes a big difference in performance. >> >> Win

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread David Boreham
On 8/24/2011 1:32 PM, Tomas Vondra wrote: Why is that important? It's simply a failure of electronics and it has nothing to do with the wear limits. It simply fails without prior warning from the SMART. In the cited article (actually in all articles I've read on this subject), the failures we

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread gnuoytr
Original message >Date: Wed, 24 Aug 2011 21:32:16 +0200 >From: pgsql-performance-ow...@postgresql.org (on behalf of "Tomas Vondra" >) >Subject: Re: [PERFORM] Reports from SSD purgatory >To: gnuo...@rcn.com >Cc: pgsql-performance@postgresql.org >

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread Merlin Moncure
On Wed, Aug 24, 2011 at 2:32 PM, Tomas Vondra wrote: > On 24 Srpen 2011, 20:48, gnuo...@rcn.com wrote: > >> It's worth knowing exactly what that means.  Turns out that NAND quality >> is price specific.  There's gooduns and baduns.  Is this a failure in the >> controller(s) or the NAND? > > Why is

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread Tomas Vondra
On 24 Srpen 2011, 20:48, gnuo...@rcn.com wrote: > It's worth knowing exactly what that means. Turns out that NAND quality > is price specific. There's gooduns and baduns. Is this a failure in the > controller(s) or the NAND? Why is that important? It's simply a failure of electronics and it ha

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread david
On Wed, 24 Aug 2011, Merlin Moncure wrote: On Wed, Aug 24, 2011 at 1:48 PM, wrote: Also, given that PG is *nix centric and support for TRIM is win centric, having that makes a big difference in performance. one point about TRIM -- no raid controller that I know of supports trim, which s

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread Merlin Moncure
On Wed, Aug 24, 2011 at 1:48 PM, wrote: > > > Original message >>Date: Mon, 15 Aug 2011 19:49:52 -0400 >>From: pgsql-performance-ow...@postgresql.org (on behalf of Greg Smith >>) >>Subject: [PERFORM] Reports from SSD purgatory >>To: "pgsql-p

Re: [PERFORM] Reports from SSD purgatory

2011-08-24 Thread gnuoytr
Original message >Date: Mon, 15 Aug 2011 19:49:52 -0400 >From: pgsql-performance-ow...@postgresql.org (on behalf of Greg Smith >) >Subject: [PERFORM] Reports from SSD purgatory >To: "pgsql-performance@postgresql.org" > >News update for anyone else who

Re: [PERFORM] Reports from SSD purgatory

2011-08-19 Thread Greg Smith
On 08/15/2011 07:49 PM, Greg Smith wrote: News update for anyone else who's trapped like me, waiting for a fix to the Intel 320 SSD bug where they can truncate themselves to 8MB. Over the weekend Intel has announced a firmware fix for the problem is done, and is due to ship "within the next tw

Re: [PERFORM] Reports from SSD purgatory

2011-08-15 Thread David Boreham
This comment by the author I think tends to support my theory that most of the failures seen are firmware related (and not due to actual hardware failures, which as I mentioned in the previous thread are very rare and should occur roughly equally often in hard drives as SSDs) : /As we expla

[PERFORM] Reports from SSD purgatory

2011-08-15 Thread Greg Smith
News update for anyone else who's trapped like me, waiting for a fix to the Intel 320 SSD bug where they can truncate themselves to 8MB. Over the weekend Intel has announced a firmware fix for the problem is done, and is due to ship "within the next two weeks": http://communities.intel.com/th