Re: [PERFORM] availability of SATA vendors
On Fri, 17 Nov 2006, Luke Lonergan wrote: Currently, I'm looking at Penguin, HP and Sun (though Sun's store isn't working for me at the moment). Maybe I just need to order a Penguin and then buy the controller separately, but was hoping to get support from a single entity. Rackable or Asacomputers sell and support systems with the 3Ware or Areca controllers. Luke, ASAcomputers has been the most helpful of all the vendors so far, so thanks for point me at them. I know you've been posting results with the Areca and 3ware controllers, do you have a preference for one over the other? It seems that you can only get 256MB cache with the 3ware 9550SX and you can get 512MB with the 9650SE, but only the Areca cards go up to 1GB. I'm curious how big a performance gain we would see going from 256MB cache to 512MB to 1GB. This is for a web site backend DB which is mostly read intensive, but occassionally has large burts of write activity due to new user signups generated by the marketing engine. -- Jeff Frost, Owner [EMAIL PROTECTED] Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---(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
[PERFORM] Priority to a mission critical transaction
Hi, We have an application that is mission critical, normally very fast, but when an I/O or CPU bound transaction appears, the mission critical application suffers. Is there a way go give some kind of priority to this kind of application? Reimer
Re: [PERFORM] availability of SATA vendors
ASAcomputers has been the most helpful of all the vendors so far, so thanks for point me at them. I know you've been posting results with the Areca and 3ware controllers, do you have a preference for one over the other? It seems that you can only get 256MB cache with the 3ware 9550SX and you can get 512MB with the 9650SE, but only the Areca cards go up to 1GB. Don't count out LSI either. They make a great SATA controller based off their very well respected SCSI controller. Sincerely, Joshua D. Drake I'm curious how big a performance gain we would see going from 256MB cache to 512MB to 1GB. This is for a web site backend DB which is mostly read intensive, but occassionally has large burts of write activity due to new user signups generated by the marketing engine. -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate ---(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] availability of SATA vendors
On Tue, 21 Nov 2006, Joshua D. Drake wrote: ASAcomputers has been the most helpful of all the vendors so far, so thanks for point me at them. I know you've been posting results with the Areca and 3ware controllers, do you have a preference for one over the other? It seems that you can only get 256MB cache with the 3ware 9550SX and you can get 512MB with the 9650SE, but only the Areca cards go up to 1GB. Don't count out LSI either. They make a great SATA controller based off their very well respected SCSI controller. Interesting. Does it perform as well as the ARECAs and how much BBU cache can you put in it? Oh, does it use the good ole megaraid_mbox driver as well? -- Jeff Frost, Owner [EMAIL PROTECTED] Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---(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
