Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-03 Thread Yeb Havinga
On 2011-11-02 16:06, Magnus Hagander wrote: On Wed, Nov 2, 2011 at 16:04, Yeb Havinga wrote: On 2011-11-02 15:06, Kevin Grittner wrote: Yeb Havingawrote: I'm now contemplating not using the 710 at all. Why should I not buy two 6Gbps SSDs without supercap (e.g. Intel 510 and OCZ Vertex 3

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-03 Thread Yeb Havinga
On 2011-11-03 15:31, Shaun Thomas wrote: On 11/03/2011 04:38 AM, Yeb Havinga wrote: Both comparable near 10K tps. That's another thing I was wondering about. Why are we talking about Vertex 2 Pro's, anyway? The Vertex 3 Pros post much better results and are still capacitor-backed. Not f

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-03 Thread Shaun Thomas
On 11/03/2011 04:38 AM, Yeb Havinga wrote: Both comparable near 10K tps. That's another thing I was wondering about. Why are we talking about Vertex 2 Pro's, anyway? The Vertex 3 Pros post much better results and are still capacitor-backed. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blv

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-03 Thread Merlin Moncure
On Thu, Nov 3, 2011 at 4:38 AM, Yeb Havinga wrote: > On 2011-11-02 22:08, Merlin Moncure wrote: >> >> On Wed, Nov 2, 2011 at 3:45 PM, Yeb Havinga  wrote: >>> >>> Intel latency graph at http://imgur.com/Hh3xI >>> Ocz latency graph at http://imgur.com/T09LG >> >> curious: what were the pgbench resul

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-03 Thread Yeb Havinga
On 2011-11-02 22:08, Merlin Moncure wrote: On Wed, Nov 2, 2011 at 3:45 PM, Yeb Havinga wrote: Intel latency graph at http://imgur.com/Hh3xI Ocz latency graph at http://imgur.com/T09LG curious: what were the pgbench results in terms of tps? merlin Both comparable near 10K tps. -- Yeb -- S

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Andy
Your results are consistent with the benchmarks I've seen. Intel SSD have much worse write performance compared to SSD that uses Sandforce controllers, which Vertex 2 Pro does. According to this benchmark, at high queue depth the random write performance of Sandforce is more than 5 times that o

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Merlin Moncure
On Wed, Nov 2, 2011 at 3:45 PM, Yeb Havinga wrote: > On 2011-11-02 16:16, Yeb Havinga wrote: >> >> On 2011-11-02 15:26, Merlin Moncure wrote: >> >>> I would keep at least 20-30% of both drives unpartitioned to leave the >>> controller room to wear level and as well as other stuff.  I'd try >>> wip

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Yeb Havinga
On 2011-11-02 16:16, Yeb Havinga wrote: On 2011-11-02 15:26, Merlin Moncure wrote: I would keep at least 20-30% of both drives unpartitioned to leave the controller room to wear level and as well as other stuff. I'd try wiping the drives, reparititoing, and repeating your test. I would also c

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Merlin Moncure
On Wed, Nov 2, 2011 at 10:16 AM, Yeb Havinga wrote: > On 2011-11-02 15:26, Merlin Moncure wrote: >> >> On Wed, Nov 2, 2011 at 8:05 AM, Yeb Havinga  wrote: >>> >>> Hello list, >>> >>> A OCZ Vertex 2 PRO and Intel 710 SSD, both 100GB, in a software raid 1 >>> setup. I was pretty convinced this was t

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread David Boreham
So the Intel 710 kind of sucks latency wise. Is it because it is also heavily reading, and maybe WAL should not be put on it? A couple quick thoughts: 1. There are a lot of moving parts in the system besides the SSDs. It will take some detailed analysis to determine the cause for the outlyi

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Yeb Havinga
On 2011-11-02 15:26, Merlin Moncure wrote: On Wed, Nov 2, 2011 at 8:05 AM, Yeb Havinga wrote: Hello list, A OCZ Vertex 2 PRO and Intel 710 SSD, both 100GB, in a software raid 1 setup. I was pretty convinced this was the perfect solution to run PostgreSQL on SSDs without a IO controller with BB

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Magnus Hagander
On Wed, Nov 2, 2011 at 16:04, Yeb Havinga wrote: > On 2011-11-02 15:06, Kevin Grittner wrote: >> >> Yeb Havinga  wrote: >> >>> I'm now contemplating not using the 710 at all. Why should I not >>> buy two 6Gbps SSDs without supercap (e.g. Intel 510 and OCZ Vertex >>> 3 Max IOPS) with a IO controlle

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Yeb Havinga
On 2011-11-02 15:06, Kevin Grittner wrote: Yeb Havinga wrote: I'm now contemplating not using the 710 at all. Why should I not buy two 6Gbps SSDs without supercap (e.g. Intel 510 and OCZ Vertex 3 Max IOPS) with a IO controller+BBU? Wouldn't the data be subject to loss between the time the IO

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Merlin Moncure
On Wed, Nov 2, 2011 at 8:05 AM, Yeb Havinga wrote: > Hello list, > > A OCZ Vertex 2 PRO and Intel 710 SSD, both 100GB, in a software raid 1 > setup. I was pretty convinced this was the perfect solution to run > PostgreSQL on SSDs without a IO controller with BBU. No worries for strange > firmware

Re: [PERFORM] Intel 710 pgbench write latencies

2011-11-02 Thread Kevin Grittner
Yeb Havinga wrote: > I'm now contemplating not using the 710 at all. Why should I not > buy two 6Gbps SSDs without supercap (e.g. Intel 510 and OCZ Vertex > 3 Max IOPS) with a IO controller+BBU? Wouldn't the data be subject to loss between the time the IO controller writes to the SSD and the t