Re: benchmark woes and XFS options - Mailing list pgsql-performance

From Greg Smith
Subject Re: benchmark woes and XFS options
Date
Msg-id 4E40AC9B.9090400@2ndquadrant.com
Whole thread Raw
In response to benchmark woes and XFS options  ("mark" <dvlhntr@gmail.com>)
Responses Re: benchmark woes and XFS options  ("mark" <dvlhntr@gmail.com>)
List pgsql-performance
I think your notion that you have an HP CCISS driver in this older
kernel that just doesn't drive your card very fast is worth exploring.
What I sometimes do in the situation you're in is boot a Linux
distribution that comes with a decent live CD, such as Debian or
Ubuntu.  Just mount the suspect drive, punch up read-ahead, and re-test
performance.  That should work well enough to do a simple dd test, and
probably well enough to compile and run bonnie++ too.  If that gives
good performance numbers, it should narrow the list of possible causes
considerably.  You really need to separate out "bad driver" from the
other possibilities here given what you've described, and that's a low
impact way to do it.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us


pgsql-performance by date:

Previous
From: "mark"
Date:
Subject: benchmark woes and XFS options
Next
From: Greg Smith
Date:
Subject: Re: Postgres performance on Linux and Windows