LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Blogs
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.
Old

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

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

Remote management of Linux systems via Python and ssh (Part 2)

Posted 02-03-2009 at 08:44 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 06:50 PM by rocket357 (modified code)

My last blogpost on Python/SSH seemed to be popular, so here I am again with a more in-depth look at what can be accomplished with this pairing.

To recap, I manage 300 databases, some M$ SQL Server, some PostgreSQL. There are a ton of Apache/Linux machines on our network and quite a few "traffic cops" based on Linux and BSD (as well as a few Cisco machines) for routing external traffic to internal machines. Pretty standard stuff. The IT department has a director, a network...
Member
Posted in Python
Views 4686 Comments 0 rocket357 is offline
Old

Thoughts on problem solving for new Linux users

Posted 02-02-2009 at 12:40 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 02-03-2009 at 09:05 PM by rocket357

One of the hardest issues to grasp for many Linux newbies is not a Linux issue, rather it's their problem-solving approach. With the closed-source Windows business model, you really only have one problem-solving option available: tech support. While members at sites such as LQ do their very best to provide something like tech support, there really is a lot more that newbies can do to speed up both their understanding of Linux and finding a solution to whatever problem they're looking at right...
Member
Posted in Uncategorized
Views 1446 Comments 2 rocket357 is offline
Old

Getting serious with PostgreSQL

Posted 01-29-2009 at 10:45 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)

Ok, so the company I work for has set a hard date for the release/launch of our new flagship product...June 1st.

This is interesting for a number of reasons. First, the 5.0 project has been in "under heavy development" status for a seriously long time now (late 2007 I joined the 5.0 team, which at that time was roughly 20% done. I later moved from that team to the reporting division, spent a year there and then moved to my current role as DBA). I figured the 5.0 project...
Member
Posted in Uncategorized
Views 1058 Comments 0 rocket357 is offline

  



All times are GMT -5. The time now is 08:33 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
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration