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 D06ABD1BB5F for ; Mon, 8 Mar 2004 22:12:30 +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 34003-03 for ; Mon, 8 Mar 2004 18:12:30 -0400 (AST) Received: from mta02.ono.com (smtp.ono.com [62.42.230.12]) by svr1.postgresql.org (Postfix) with ESMTP id DEC3BD1BAF8 for ; Mon, 8 Mar 2004 18:12:27 -0400 (AST) Received: from ono.com (81.203.13.185) by mta02.ono.com (7.0.024) id 403435F3000796A2 for pgsql-admin@postgresql.org; Mon, 8 Mar 2004 23:12:29 +0100 Message-ID: <404CEFC6.10300@ono.com> Date: Mon, 08 Mar 2004 23:12:22 +0100 From: Juan Miguel User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: es-es, en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: Postgres and multiprocessor? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/139 X-Sequence-Number: 12708 >>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. >> >> Linux OS, can explode multiprocessors servers, therefore, each session on postgres (a session = a process), can be allocated in a processor. Multiple processors can help you, if you have a great number of sessions (concurrently users connected to the database performing queries or transactions). For example, if you have 2 CPUs, then the system can run 2 sessions at the same time (really this is not true, there are problems acceding the buses, hardisk, raid, cache,...). If the operations are heavy loaded calcs, then it helps your performance(throughput). Even so, often, in theory, when you need a high number of concurrent sessions, it's better to increase your RAM, speed up your busses or HDs, change your filesystems or your RAID, ... or making a cluster with some servers (I want to create a DB postgres cluster with two linux boxes, for balancing the load)