At 18:35 +0300 on 10/08/1999, Hitesh Patel wrote:
> I am running Postgres on a Linux 2.2.11 box with 2 Pentium III 550
> processors. It appears that postgres is only using the first processor
> and not both.
Postgres is not multi-threaded. It's multi-process. Each of its processes
has only one thread, and that thread can only run on one CPU at one time.
But are you sure that when Postgres spawns sub-processes, those processes
don't run on the second CPU? This is something the operating system should
support - distributing the load of processes between CPUs. It doesn't
actually have anything to do with PostgreSQL per se.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma