×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Multiple CPU/NIC

Multiple CPU/NIC

Multiple CPU/NIC

(OP)
I am new to PostgreSQL and Linux.

I am running PostgreSQL 7.2.1 on RedHat 7.3 on a Dell Poweredge 2600 w/2 processors and 2 NICS.

Is there anything I specifically need to do w/PostgreSQL to get it to take advantage of the extra processor and NIC?  (Or are those matters completely OS related?)

The database will be the back-end for an in house time & attendance system and I want to be sure that I get the best performance possible.

  Thanks for any help.

     Ron

RE: Multiple CPU/NIC

Hello Theologian. Haven't we had a few discussions in the past?

Anyway, you should be fine with PostgreSQL on multiple CPUs as long as your kernel is compiled right. Since PostgreSQL is a process-oriented, I believe this means the OS simply decides which processor to spawn new processes on, thus distributing the load quite simply.

Since PostgreSQL only receives connections, it doesn't matter which incoming NIC receives the request, as long as the remote host is in the pg_hba.conf file. Thus, it is up to your application logic to handle distribution of load between the two IP addresses on the server.

You might want to read the following docs regarding performance tuning:

http://www.postgresql.org/idocs/index.php?runtime.html

http://www.ca.postgresql.org/docs/m...hw_performance/

http://www.argudo.org/postgresql/soft-tuning.html


Also, you might want to upgrade to PostgreSQL version 7.2.3, which fixes a couple of bugs.

-------------------------------------------

Big Brother: "War is Peace" -- Big Business: "Trust is Suspicion"
(http://www.cl.cam.ac.uk/~rja14/tcpa-faq.html)

RE: Multiple CPU/NIC

(OP)
thanks for the links rycamor

I know that I should upgrade but I don't know that I will.

I'm in a bit of a bind.  They want this project done yesterday.  The server just came in and I am silmultaneously learning linux, apache, php and postgres.  The box I ordered came w/postgres already installed and I'm a bit nervous to mess w/it until I know 100% what I am doing.  I'm sure the database is installed from the rpm so I need to read up on how to upgrade.

If I had more time I would install the OS myself and build a lot of this stuff from source but I don't have that luxury.  (I've done lots of desk top installs of redhat on my test machine but this is a server w/raid and so on)

  Thanks again for your help.

             Ron

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close