pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Juan Miguel <juanmime@ono.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres and multiprocessor?
Date: Mon, 08 Mar 2004 23:12:22 +0100
Message-ID: <404CEFC6.10300@ono.com> (raw)
In-Reply-To: <Pine.LNX.4.33.0403081408430.2365-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0403081408430.2365-100000@css120.ihs.com>


>>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)




view thread (5+ messages)

Message-ID: <404CEFC6.10300@ono.com>
Permalink:  ../404CEFC6.10300@ono.com/
Also on:    postgresql.org/message-id/404CEFC6.10300@ono.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: juanmime@ono.com
  Subject: Re: Postgres and multiprocessor?
  In-Reply-To: <404CEFC6.10300@ono.com>
  References: <Pine.LNX.4.33.0403081408430.2365-100000@css120.ihs.com> <404CEFC6.10300@ono.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox