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:





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

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