Re: How to run multi-processor question

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