LinuxQuestions.org - PostgreSQL Stuff

PostgreSQL Stuff As far as databases go, and as far as I'm concerned, **this** is the good stuff.

PostgreSQL - installation/configuration/benchmarking - on Dell servers Part II

Posted 03-27-2009 at 09:02 PM by rocket357
Updated 10-27-2009 at 07:44 PM by rocket357

(Continued from this blog post)

Now test the setup:

Code:

linux ~ # hdparm -tT /dev/sdc

/dev/sdc:
 Timing cached reads:   11464 MB in  2.00 seconds = 5739.66 MB/sec
 Timing buffered disk reads:  1816 MB in  3.00 seconds = 604.39 MB/sec

Looks good. Now let's format the partition:

I like xfs. I use xfs. You might not...so run "man mkfs.<your_favorite_filesystem>" to read up on how to convert...

rocket357

Member

Posted in PostgreSQL Stuff

Views 1629 Comments 0 rocket357 is offline

PostgreSQL - installation/configuration/benchmarking - on Dell servers

Posted 03-27-2009 at 08:20 PM by rocket357
Updated 10-27-2009 at 07:45 PM by rocket357

Dell has historically had a pretty low-end line of RAID cards (the PowerEdge Expandable RAID Controller, or PERC for short) that have required tons of time and care to get them operating at a reasonable level. This blog post will cover my experiences with the PERC6/E line of cards (which aren't that bad, especially compared to previous versions) and how to get optimal performance out of them on Dell 1950/2950 machines, as well as PostgreSQL general configuration.

DISCLAIMER: I don't...

rocket357

Member

Posted in PostgreSQL Stuff

Views 1265 Comments 0 rocket357 is offline