From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to run multi-processor question |
Date: | 2002-06-26 16:18:33 |
Message-ID: | 3D19E959.7060904@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-06-26 16:44:32 | Re: How can I describe a table with select * ... |
Previous Message | Alvar Freude | 2002-06-26 16:18:26 | Re: Still problems with memory swapping and server load |