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
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
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
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