pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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