LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Blogs > rocket357
User Name
Password

Notices

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

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...
Member
Views 1629 Comments 0 rocket357 is offline Edit Tags
Old

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...
Member
Views 1265 Comments 0 rocket357 is offline Edit Tags


All times are GMT -5. The time now is 05:40 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
RSS2  LQ Podcast
RSS2  LQ Radio
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: @linuxquestions
Open Source Consulting | Domain Registration