X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 49E2CD1B51F for ; Mon, 8 Mar 2004 16:54:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48577-04 for ; Mon, 8 Mar 2004 12:54:18 -0400 (AST) Received: from mail3.worldispnetwork.com (linux403.worldispnetwork.com [66.132.146.16]) by svr1.postgresql.org (Postfix) with SMTP id 8662BD1D9E6 for ; Mon, 8 Mar 2004 12:54:14 -0400 (AST) Received: (qmail 10029 invoked by uid 399); 8 Mar 2004 16:51:11 -0000 Received: from unknown (HELO px.nrglinx.local) (postmaster@linxtechnologies.com@65.124.40.1) by linux403.worldispnetwork.com with SMTP; 8 Mar 2004 16:51:10 -0000 Received: from [192.168.0.65] (helo=nrglinxmain.nrglinx.local) by px.nrglinx.local with esmtp (Exim 3.35 #1 (Debian)) id 1B0O10-0005Hs-00 for ; Mon, 08 Mar 2004 08:54:06 -0800 Received: from harvey.nrglinx.local ([192.168.0.133]) by nrglinxmain.nrglinx.local with Microsoft SMTPSVC(5.0.2195.6713); Mon, 8 Mar 2004 08:54:06 -0800 Subject: Re: Postgres and multiprocessor? From: Corey Edwards To: mlists Cc: PG Admin In-Reply-To: <404C49BD.6010007@panforma.co.yu> References: <404C49BD.6010007@panforma.co.yu> Content-Type: text/plain Organization: Linx Technologies Message-Id: <1078764845.15265.8.camel@harvey> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Mon, 08 Mar 2004 08:54:06 -0800 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 08 Mar 2004 16:54:06.0290 (UTC) FILETIME=[F7D64B20:01C4052D] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/126 X-Sequence-Number: 12695 On Mon, 2004-03-08 at 02:23, mlists wrote: > Can PostgreSQL use multiple processors if they are present in a > computer, and if so, how much will it speed up database server? Tnx in > advance. Postgres has no special functionality regarding processors. Each connection is handled by a separate process. A multi-CPU aware OS is then free to run those as best it sees fit. Given that databases are typically RAM or I/O bound as they scale, adding more processors to a machine is not a silver bullet. Performance is extremely dependent on the situation. If you really need a number to satisfy a PHB, try 42. Corey