Re: How to run multi-processor question - Mailing list pgsql-general

From Bill Moran
Subject Re: How to run multi-processor question
Date
Msg-id 3D19E959.7060904@potentialtech.com
Whole thread Raw
In response to How to run multi-processor question  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
Johnson, Shaunn wrote:
> Howdy:
>
> Running Postgres 7.1.3 on RedHat Linux 7.2 kernel 2.4.7
> on an Intel box.
>
> We are thinking about upgrading the box and adding a
> second processor.  Provided that I can physically put
> a second CPU in, how can I configure Postgres to
> work with more than one proc, or better yet, submit jobs
> to the least busiest proc.  What other things should I
> be aware of?

If your Linux is properly configured to use multiple
processors, PostgreSQL will work with no further tweaking.
Since PostgreSQL starts a new process for each connection,
it's up to the kernel to schedule execution properly, so
that both processors get used.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com




pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Still problems with memory swapping and server load
Next
From: Alvaro Herrera
Date:
Subject: Re: How can I describe a table with select * ...