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 E0363D1B979 for ; Mon, 8 Mar 2004 10:58:42 +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 53492-10 for ; Mon, 8 Mar 2004 06:58:41 -0400 (AST) Received: from elbereth.noviforum.si (unknown [193.189.169.66]) by svr1.postgresql.org (Postfix) with ESMTP id 8F31FD1B53C for ; Mon, 8 Mar 2004 06:58:37 -0400 (AST) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i28AtKHh004701; Mon, 8 Mar 2004 11:55:20 +0100 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i28AtK1e004700; Mon, 8 Mar 2004 11:55:20 +0100 Date: Mon, 8 Mar 2004 11:55:20 +0100 From: Grega Bremec To: mlists Cc: pgsql-admin@postgresql.org Subject: Re: Postgres and multiprocessor? Message-ID: <20040308105520.GA4669@elbereth.noviforum.si> References: <404C49BD.6010007@panforma.co.yu> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="vkogqOf2sHV7VnPd" Content-Disposition: inline In-Reply-To: <404C49BD.6010007@panforma.co.yu> User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/118 X-Sequence-Number: 12687 --vkogqOf2sHV7VnPd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Mon, Mar 08, 2004 at 11:23:57AM +0100, mlists used the keyboard: > > Can PostgreSQL use multiple processors if they are present in a=20 > computer, and if so, how much will it speed up database server? Tnx in=20 > advance. >=20 > Dragan It can, on platforms that support SMP. The load will be balanced across the processors on a per-backend basis, that is, an even number of concurrent connections have a good chance of being spread across both processors evenl= y, but that may vary according to the actual load on the machine. PostgreSQL backend is, for the time being, not multithreaded, which means that one single connection to the database backend will not experience any benefit due to SMP architecture of the database server. Hope this helped, --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --vkogqOf2sHV7VnPd Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFATFEYDo/EMYD4+osRAjvpAJ4kC1y/q7TOKrSLjs+Y8VYGROTANgCfftGi l7JLzjKwPvx00TU8kHGIU+Y= =fMr9 -----END PGP SIGNATURE----- --vkogqOf2sHV7VnPd--