LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Blogs > Musings on technology, philosophy, and life in the corporate world
User Name
Password

Notices



Hi. I'm a Unix Administrator, mathematics enthusiast, and amateur philosopher. This is where I rant about that which upsets me, laugh about that which amuses me, and jabber about that which holds my interest most: Unix.
PostgreSQL Stuff As far as databases go, and as far as I'm concerned, **this** is the good stuff.
Old

OOM Killer and acquisitions...a match made in heaven!

Posted 11-25-2009 at 10:17 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 11-25-2009 at 10:28 AM by rocket357

Yesterday afternoon one of my coworkers enlisted the help of employees company wide to load test a project we'd worked on together about a year ago. He'd made significant changes to the application server and wanted to see how much the server could handle in raw traffic/requests. So at 2:30 PM, half of the company I work for started hitting the application server running bogus reports...

I watched the PostgreSQL database backend while all of this was going on. By 2:34 PM, the system...
Member
Views 1004 Comments 0 rocket357 is offline
Old

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

Posted 03-27-2009 at 09:02 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
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 3593 Comments 0 rocket357 is offline
Old

PostgreSQL - installation/configuration/benchmarking - on Dell servers

Posted 03-27-2009 at 08:20 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 12-31-2009 at 11:44 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 2875 Comments 0 rocket357 is offline

  



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

Main Menu
Advertisement

Advertisement
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
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration