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

Re: [PERFORM] strange pgbench results (as if blocked at the end)

2011-08-15 Thread Greg Smith
On 08/14/2011 01:33 PM, Tom Lane wrote: (The changes in question were purely for performance, and involved a conversion from write barriers in the block layer to flush+fua, whatever that is.) Furthermore, this affected every filesystem not only ext4, so it really entirely fails to support Greg's

Re: [PERFORM] How to see memory usage using explain analyze ?

2011-08-15 Thread Igor Neyman
> -Original Message- > From: hyelluas [mailto:helen_yell...@mcafee.com] > Sent: Friday, August 12, 2011 5:30 PM > To: pgsql-performance@postgresql.org > Subject: How to see memory usage using explain analyze ? > > Hello, > > I need to compare quiery execution : I have 2 tables partition