Re: [GENERAL] Solid State Drives with PG

2010-04-08 Thread Yeb Havinga
Gordan Bobic wrote: John R Pierce wrote: all the enterprise SAN guys I've talked with say the Intel x25 drives are consumer junk, about the only thing they will use is STEC Zeus, and even then they mirror them. A couple of points there. 1) Mirroring flash drives is a bit ill advised since f

Re: [GENERAL] Solid State Drives with PG

2010-04-07 Thread Greg Smith
Gordan Bobic wrote: How much of that dislike of Intel is actually justified by something other than the margins offered / procurement policy (a.k.a. buying from the vendor that sends you the best present rather than from the vendor that has the best product)? Intel X25-E drives have write endu

Re: [GENERAL] Solid State Drives with PG

2010-04-07 Thread Gordan Bobic
John R Pierce wrote: all the enterprise SAN guys I've talked with say the Intel x25 drives are consumer junk, about the only thing they will use is STEC Zeus, and even then they mirror them. A couple of points there. 1) Mirroring flash drives is a bit ill advised since flash has a rather pr

Re: [GENERAL] Solid State Drives with PG

2010-04-07 Thread John R Pierce
Vick Khera wrote: On Wed, Apr 7, 2010 at 4:43 PM, Merlin Moncure wrote: except that the fault tolerance issue isn't worked out yet. Yep. I do not want to be the guy doing the product testing to see if they're suitable for a high-write DB load. all the enterprise SAN guys I've ta

Re: [GENERAL] Solid State Drives with PG

2010-04-07 Thread Vick Khera
On Wed, Apr 7, 2010 at 4:43 PM, Merlin Moncure wrote: > except that the fault tolerance issue isn't worked out yet. Yep. I do not want to be the guy doing the product testing to see if they're suitable for a high-write DB load. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Solid State Drives with PG

2010-04-07 Thread Merlin Moncure
On Wed, Apr 7, 2010 at 3:27 PM, Vick Khera wrote: > On Fri, Mar 26, 2010 at 3:50 PM, Merlin Moncure wrote: >> here is a _used_ 320gb ramsan for 15k :-).  dram storage is pricey. >> > > I think using DRAM as the base is way better than flash.  Just use the > flash or a regular disk as the backup w

Re: [GENERAL] Solid State Drives with PG

2010-04-07 Thread Vick Khera
On Fri, Mar 26, 2010 at 3:50 PM, Merlin Moncure wrote: > here is a _used_ 320gb ramsan for 15k :-).  dram storage is pricey. > I think using DRAM as the base is way better than flash. Just use the flash or a regular disk as the backup with a battery to power the backup operation. I have in my s

Re: [GENERAL] Solid State Drives with PG

2010-03-26 Thread Merlin Moncure
On Fri, Mar 26, 2010 at 3:43 PM, Brad Nicholson wrote: > I'm not sure what the price point is though. here is a _used_ 320gb ramsan for 15k :-). dram storage is pricey. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww

Re: [GENERAL] Solid State Drives with PG

2010-03-26 Thread Brad Nicholson
On Fri, 2010-03-26 at 15:27 -0400, Merlin Moncure wrote: > On Fri, Mar 26, 2010 at 2:32 PM, Greg Smith wrote: > > Merlin Moncure wrote: > >> > >> So flash isn't yet a general purpose database solution, and wont be until > >> the write performance problem is fixed in a way that doesn't > >> comprom

Re: [GENERAL] Solid State Drives with PG

2010-03-26 Thread Merlin Moncure
On Fri, Mar 26, 2010 at 2:32 PM, Greg Smith wrote: > Merlin Moncure wrote: >> >> So flash isn't yet a general purpose database solution, and wont be until >> the write performance problem is fixed in a way that doesn't >> compromise on volatility. > > Flash drives that ship with a supercapacitor l

Re: [GENERAL] Solid State Drives with PG

2010-03-26 Thread Greg Smith
Merlin Moncure wrote: So flash isn't yet a general purpose database solution, and wont be until the write performance problem is fixed in a way that doesn't compromise on volatility. Flash drives that ship with a supercapacitor large enough to ensure orderly write cache flushing in the event o

Re: [GENERAL] Solid State Drives with PG (was: in RAM DB)

2010-03-26 Thread Merlin Moncure
On Fri, Mar 26, 2010 at 10:32 AM, Alan McKay wrote: >> Have you considered using one of these: >> http://www.acard.com/english/fb01-product.jsp?idno_no=270&prod_no=ANS-9010&type1_title= >> Solid State Drive&type1_idno=13 > > We did some research which suggested that performance may not be so > gre

[GENERAL] Solid State Drives with PG (was: in RAM DB)

2010-03-26 Thread Alan McKay
> Have you considered using one of these: > http://www.acard.com/english/fb01-product.jsp?idno_no=270&prod_no=ANS-9010&type1_title= > Solid State Drive&type1_idno=13 We did some research which suggested that performance may not be so great with them because the PG engine is not optimized to utiliz