Re: [PERFORM] Ultra-cheap NVRAM device
[EMAIL PROTECTED] (Dan Harris) writes: On Oct 3, 2005, at 5:02 AM, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): Replying before my other post came through.. It looks like their benchmarks are markedly improved since the last article I read on this. There may be more interest now.. It still needs a few more generations worth of improvement. 1. It's still limited to SATA speed 2. It's not ECC smart What I'd love to see would be something that much smarter, or, at least, that pushes the limits of SATA speed, and which has both a battery on board and enough CF storage to cope with outages. -- output = reverse(gro.mca @ enworbbc) http://www.ntlug.org/~cbbrowne/linuxxian.html We all live in a yellow subroutine, a yellow subroutine, a yellow subroutine... ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] Ultra-cheap NVRAM device
Chris wrote: [EMAIL PROTECTED] (Dan Harris) writes: On Oct 3, 2005, at 5:02 AM, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): Replying before my other post came through.. It looks like their benchmarks are markedly improved since the last article I read on this. There may be more interest now.. It still needs a few more generations worth of improvement. 1. It's still limited to SATA speed 2. It's not ECC smart 3. Another zero (or two) on the price tag :). While it looks like a fun toy to play with, for it to replace hard drives in server environments they need to provide more emphasis and effort in assuring people their drive is reliable. If they really wanted it to be adopted in server environments, it would have been packaged in a 3.5 drive, not a pci card, since that's what we all hot swap (especially since it already uses SATA interface). They would also have allowed use of 2 and 4gb DIMS, and put in a small hard drive that the memory paged to when powered off, and completely isolated the power supply...hard to pack all that in 60$. That said, we are in the last days of the hard disk. I think it is only a matter of months before we see a sub 1000$ part which have zero latency in the 20-40 GB range. Once that happens economies of scale will kick in and hard drives will become basically a backup device. Merlin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] Ultra-cheap NVRAM device
There was a discussion about this about 2 months ago. See the archives. On Mon, Oct 03, 2005 at 01:02:26PM +0200, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): http://www.tomshardware.com/storage/20050907/index.html Anybody know a good reason why you can't put a WAL on this, and enjoy a hefty speed boost for a fraction of the price of a traditional SSD? (Yes, it's SATA, not PCI, so the throughput is not all that impressive -- but still, it's got close to zero seek time.) /* Steinar */ -- Homepage: http://www.sesse.net/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] Ultra-cheap NVRAM device
On Oct 3, 2005, at 5:02 AM, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): This has been posted before, and the main reason nobody got very excited is that: a) it only uses the PCI bus to provide power to the device, not for I/O b) It is limited to SATA bandwidth c) The benchmarks did not prove it to be noticeably faster than a good single SATA drive A few of us were really excited at first too, until seeing the benchmarks.. -Dan ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] Ultra-cheap NVRAM device
On Oct 3, 2005, at 5:02 AM, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): Replying before my other post came through.. It looks like their benchmarks are markedly improved since the last article I read on this. There may be more interest now.. -Dan ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PERFORM] Ultra-cheap NVRAM device
On Mon, 2005-10-03 at 11:15 -0600, Dan Harris wrote: On Oct 3, 2005, at 5:02 AM, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): This has been posted before, and the main reason nobody got very excited is that: a) it only uses the PCI bus to provide power to the device, not for I/O b) It is limited to SATA bandwidth c) The benchmarks did not prove it to be noticeably faster than a good single SATA drive A few of us were really excited at first too, until seeing the benchmarks.. Also, no ECC support. You'd be crazy to use it for anything. -jwb ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] Ultra-cheap NVRAM device
Nah. It's still not right. It needs: 1= full PCI, preferably at least 64b 133MHz PCI-X, bandwidth. A RAM card should blow the doors off the fastest commodity RAID setup you can build. 2= 8-16 DIMM slots 3= a standard battery type that I can pick up spares for easily 4= ECC support If it had all those features, I'd buy it at even 2x or possibly even 3x it's current price. 8, 16, or 32GB (using 1, 2, or 4GB DIMMs respectively in an 8 slot form factor) of very fast temporary work memory (sorting anyone ;-) ). Yum. Ron -Original Message- From: Dan Harris [EMAIL PROTECTED] Sent: Oct 3, 2005 1:21 PM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Ultra-cheap NVRAM device On Oct 3, 2005, at 5:02 AM, Steinar H. Gunderson wrote: I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): Replying before my other post came through.. It looks like their benchmarks are markedly improved since the last article I read on this. There may be more interest now.. -Dan ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster