Re: [PERFORM] Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

2010-08-08 Thread Yeb Havinga
Michael March wrote: If anyone is interested I just completed a series of benchmarks of stock Postgresql running on a normal HDD vs a SSD. If you don't want to read the post, the summary is that SSDs are 5 to 7 times faster than a 7200RPM HDD drive under a pgbench load. http://it-blog.5amso

Re: [PERFORM] Advice configuring ServeRAID 8k for performance

2010-08-08 Thread Scott Marlowe
On Sun, Aug 8, 2010 at 12:46 AM, Scott Carey wrote: > > On Aug 5, 2010, at 4:09 PM, Scott Marlowe wrote: > >> On Thu, Aug 5, 2010 at 4:27 PM, Pierre C wrote: >>> 1) Should I switch to RAID 10 for performance?  I see things like "RAID 5 is bad for a DB" and "RAID 5 is slow with <= 6 driv

Re: [PERFORM] Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

2010-08-08 Thread Scott Marlowe
On Sun, Aug 8, 2010 at 12:49 AM, Michael March wrote: > >> SSD's actually vary quite a bit with typical postgres benchmark workloads. > > You mean various SSDs from different vendors? Or are you saying the same SSD > model might vary in performance from drive to drive? > >> >>  Many of them also d

Re: [PERFORM] Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

2010-08-08 Thread Michael March
> > On Sat, Aug 7, 2010 at 5:47 PM, Michael March wrote: > > If anyone is interested I just completed a series of benchmarks of stock > > Postgresql running on a normal HDD vs a SSD. > > If you don't want to read the post, the summary is that SSDs are 5 to 7 > > times faster than a 7200RPM HDD dri