Re: How to run multi-processor question

Johnson, Shaunn dijo:

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

You do nothing.  The kernel will take care of giving each backend
process the idlest processor.  PostgreSQL is multiprocess, as opposed to
the multithreaded model of MySQL and others, so PostgreSQL itself cannot
do anything about the scheduling; it is left to the operating system.

Just be sure to use an SMP kernel.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)