Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-28 Thread Amitabh Kant
On Mon, Oct 24, 2011 at 10:23 PM, David Boreham david_l...@boreham.orgwrote: A few quick thoughts: 1. 320 would be the only SSD I'd trust from your short-list. It's the only one with proper protection from unexpected power loss. 2. Multiple RAID'ed SSDs sounds like (vast) overkill for your

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-28 Thread David Boreham
On 10/28/2011 12:40 AM, Amitabh Kant wrote: Sadly, 710 is not that easily available around here at the moment. All three sizes are in stock at newegg.com, if you have a way to export from the US to your location. -- Sent via pgsql-performance mailing list

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-25 Thread Thilo Raufeisen
Am 24.10.2011 16:09, schrieb Amitabh Kant: while Intel 320 had a nasty bug which has been rectified Be careful with that Intel SSD. This one is still very buggy. Take a look at the Intel forums http://communities.intel.com/community/tech/solidstate?view=discussions#/ about users who are

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-25 Thread Claudio Freire
On Mon, Oct 24, 2011 at 11:37 PM, David Boreham david_l...@boreham.org wrote: What about redundancy? How do you swap an about-to-die SSD? Software RAID-1? The approach we take is that we use 710 series devices which have predicted reliability similar to all the other components in the

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-25 Thread David Boreham
On 10/25/2011 8:55 AM, Claudio Freire wrote: But what about unexpected failures. Faulty electronics, stuff like that? I really don't think a production server can work without at least raid-1. Same approach : a server either works or it does not. The transition between working and not

[PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-24 Thread Amitabh Kant
Hello I need to choose between Intel 320 , Intel 510 and OCZ Vertex 3 SSD's for my database server. From recent reading in the list and other places, I have come to understand that OCZ Vertex 3 should not be used, Intel 510 uses a Marvel controller while Intel 320 had a nasty bug which has been

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-24 Thread David Boreham
A few quick thoughts: 1. 320 would be the only SSD I'd trust from your short-list. It's the only one with proper protection from unexpected power loss. 2. Multiple RAID'ed SSDs sounds like (vast) overkill for your workload. A single SSD should be sufficient (will get you several thousand TPS

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-24 Thread Merlin Moncure
On Mon, Oct 24, 2011 at 11:53 AM, David Boreham david_l...@boreham.org wrote: A few quick thoughts: 1. 320 would be the only SSD I'd trust from your short-list. It's the only one with proper protection from unexpected power loss. yeah. 2. Multiple RAID'ed SSDs sounds like (vast) overkill

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-24 Thread Claudio Freire
On Mon, Oct 24, 2011 at 6:31 PM, Merlin Moncure mmonc...@gmail.com wrote: 2. Multiple RAID'ed SSDs sounds like (vast) overkill for your workload. A single SSD should be sufficient (will get you several thousand TPS on pgbench for your DB size). Also, raid controllers interfere with TRIM.

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-24 Thread David Boreham
On 10/24/2011 3:31 PM, Merlin Moncure wrote: 4. Consider using Intel 710 series rather than 320 (pay for them with the money saved from #3 above). Those devices have much, much higher specified endurance than the 320s and since your DB is quite small you only need to buy one of them. 710

Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

2011-10-24 Thread David Boreham
On 10/24/2011 4:47 PM, Claudio Freire wrote: What about redundancy? How do you swap an about-to-die SSD? Software RAID-1? The approach we take is that we use 710 series devices which have predicted reliability similar to all the other components in the machine, therefore the unit of