Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/2/2011 11:55 PM, Gregory Gerard wrote: Which repo did you get them from? http://yum.postgresql.org/9.1/redhat/rhel-$releasever-$basearch -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpr

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread Gregory Gerard
Which repo did you get them from? On Oct 2, 2011, at 10:24 PM, David Boreham wrote: > On 10/2/2011 10:49 PM, David Boreham wrote: >> >> There are some OS differences between the old and new servers : old is >> running CentOS 5.7 while the new is running 6.0. >> Old server has atime enabled whil

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/2/2011 10:49 PM, David Boreham wrote: There are some OS differences between the old and new servers : old is running CentOS 5.7 while the new is running 6.0. Old server has atime enabled while new has relatime mount option specified. Both are running PG 9.1.1 from the yum repo. Also t

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/2/2011 10:35 PM, Greg Smith wrote: That sounds about the same performance as the 320 drive I tested earlier this year then. You might try duplicating some of the benchmarks I ran on that: http://archives.postgresql.org/message-id/4d9d1fc3.4020...@2ndquadrant.com Thanks. Actually I had

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread Greg Smith
On 10/01/2011 07:39 PM, David Boreham wrote: I've already tried bonnie++, sysbench and a simple WAL emulation test program I wrote more than 10 years ago. The drive tests at around 160Mbyte/s on bulk data and 4k tps for commit rate writing small blocks. That sounds about the same performance a

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/2/2011 6:26 PM, Gregory Gerard wrote: If I may ask what were your top three candidates before choosing the intel? All the other options considered viable were using traditional rotational disks. I personally don't have any confidence in the other SSD vendors today, except perhaps for Fusi

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread Gregory Gerard
If I may ask what were your top three candidates before choosing the intel? Also why not just plan a graceful switch to a replicated server? At some point you have to detect the drive is about to go (or it just goes without warning). Presumably that point will be in a while and be coordinated wi

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/2/2011 2:33 AM, Arjen van der Meijden wrote: Given the fact that you can get two 320's for the price of one 710, its probably always a bit difficult to actually make the choice (unless you want a fixed amount of disks and the best endurance possible for that). One thing I'd add to th

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/1/2011 9:22 PM, Andy wrote: Do you have an Intel 320? I'd love to see tests comparing 710 to 320 and see if it's worth the price premium. Good question. I don't have a 320 drive today, but will probably get one for testing soon. However, my conclusion based on the Intel spec documents

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread David Boreham
On 10/1/2011 10:00 PM, Gregory Gerard wrote: How does this same benchmark compare on similar (or same) hardware but with magnetic media? I don't have that data at present :( So far I've been comparing performance with our current production machines, which are older. Those machines use 'rapto

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-02 Thread Arjen van der Meijden
#x27;s worth the price premium. *From:* David Boreham *To:* PGSQL Performance *Sent:* Saturday, October 1, 2011 10:39 PM *Subject:* [PERFORM] Suggestions for Intel 710 SSD test I have a 710 (Lyndonville) SSD in a test server. Ultimately we'll run capacity

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-01 Thread Gregory Gerard
d Boreham > To: PGSQL Performance > Sent: Saturday, October 1, 2011 10:39 PM > Subject: [PERFORM] Suggestions for Intel 710 SSD test > > > I have a 710 (Lyndonville) SSD in a test server. Ultimately we'll run > capacity tests using our application (which in turn uses PG), but

Re: [PERFORM] Suggestions for Intel 710 SSD test

2011-10-01 Thread Andy
Do you have an Intel 320?  I'd love to see tests comparing 710 to 320 and see if it's worth the price premium. From: David Boreham To: PGSQL Performance Sent: Saturday, October 1, 2011 10:39 PM Subject: [PERFORM] Suggestions for Intel 710 SSD test

[PERFORM] Suggestions for Intel 710 SSD test

2011-10-01 Thread David Boreham
I have a 710 (Lyndonville) SSD in a test server. Ultimately we'll run capacity tests using our application (which in turn uses PG), but it'll take a while to get those set up. In the meantime, I'd be happy to entertain running whatever tests folks here would like to suggest, spare time-permitting