Re: How to run multi-processor question

From: Alvaro Herrera <alvherre(at)atentus(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 17:49:38
Message-ID: Pine.LNX.4.44.0206261347200.4090-100000@cm-lcon-46-187.cm.vtr.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message s 2002-06-26 17:50:44 ordering error in query?
Previous Message Stephan Szabo 2002-06-26 17:40:53 Re: Strange behaviour of SELECT ... IN