Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Merlin Moncure
On Tue, Oct 20, 2015 at 12:28 PM, Scott Marlowe wrote: >> On Tue, Oct 20, 2015 at 9:33 AM, Scott Marlowe >> wrote: >>> We're running LSI MegaRAIDs at work with 10 SSD RAID-5 arrays, and we >>> can get ~5k to 7k tps on a -s 1 pgbench with the write cache on. >>> >>> When we turn the write cac

Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Scott Marlowe
> On Tue, Oct 20, 2015 at 9:33 AM, Scott Marlowe > wrote: >> We're running LSI MegaRAIDs at work with 10 SSD RAID-5 arrays, and we >> can get ~5k to 7k tps on a -s 1 pgbench with the write cache on. >> >> When we turn the write cache off, we get 15k to 20k tps. This is on a >> 120GB pgbench d

Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Merlin Moncure
On Tue, Oct 20, 2015 at 10:14 AM, Tomas Vondra wrote: > Hi, > > On 10/20/2015 03:30 PM, Merlin Moncure wrote: >> >> On Tue, Oct 20, 2015 at 3:14 AM, Birta Levente >> wrote: >>> >>> Hi >>> >>> I have a supermicro SYS-1028R-MCTR, LSI3108 integrated with SuperCap >>> module >>> (BTR-TFM8G-LSICVM02)

Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Tomas Vondra
Hi, On 10/20/2015 04:33 PM, Scott Marlowe wrote: We're running LSI MegaRAIDs at work with 10 SSD RAID-5 arrays, and we can get ~5k to 7k tps on a -s 1 pgbench with the write cache on. When we turn the write cache off, we get 15k to 20k tps. This is on a 120GB pgbench db that fits in memory

Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Tomas Vondra
Hi, On 10/20/2015 03:30 PM, Merlin Moncure wrote: On Tue, Oct 20, 2015 at 3:14 AM, Birta Levente wrote: Hi I have a supermicro SYS-1028R-MCTR, LSI3108 integrated with SuperCap module (BTR-TFM8G-LSICVM02) - 2x300GB 10k spin drive, as raid 1 (OS) - 2x300GB 15k spin drive, as raid 1 (for xlog) -

Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Scott Marlowe
On Tue, Oct 20, 2015 at 7:30 AM, Merlin Moncure wrote: > On Tue, Oct 20, 2015 at 3:14 AM, Birta Levente wrote: >> Hi >> >> I have a supermicro SYS-1028R-MCTR, LSI3108 integrated with SuperCap module >> (BTR-TFM8G-LSICVM02) >> - 2x300GB 10k spin drive, as raid 1 (OS) >> - 2x300GB 15k spin drive, a

Re: [GENERAL] RAID and SSD configuration question

2015-10-20 Thread Merlin Moncure
On Tue, Oct 20, 2015 at 3:14 AM, Birta Levente wrote: > Hi > > I have a supermicro SYS-1028R-MCTR, LSI3108 integrated with SuperCap module > (BTR-TFM8G-LSICVM02) > - 2x300GB 10k spin drive, as raid 1 (OS) > - 2x300GB 15k spin drive, as raid 1 (for xlog) > - 2x200GB Intel DC S3710 SSD (for DB), as

[GENERAL] RAID and SSD configuration question

2015-10-20 Thread Birta Levente
Hi I have a supermicro SYS-1028R-MCTR, LSI3108 integrated with SuperCap module (BTR-TFM8G-LSICVM02) - 2x300GB 10k spin drive, as raid 1 (OS) - 2x300GB 15k spin drive, as raid 1 (for xlog) - 2x200GB Intel DC S3710 SSD (for DB), as raid 1 So how is better for the SSDs: mdraid or controller's rai