LinuxQuestions.org - PostgreSQL Stuff

Hi. I'm jon.404, a Unix/Linux/Database/Openstack/Kubernetes Administrator, AWS/GCP/Azure Engineer, 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: *nix.

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

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

Posted 11-25-2009 at 09:17 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 11-25-2009 at 09: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...

rocket357

Member

Posted in PostgreSQL Stuff

Views 2021 Comments 0 rocket357 is offline

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

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

PostgreSQL - installation/configuration/benchmarking - on Dell servers

Posted 03-27-2009 at 07:20 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 12-31-2009 at 10: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...

rocket357

Member

Posted in PostgreSQL Stuff

Views 4117 Comments 0 rocket357 is offline

Page 2 of 2