| From: | Grega Bremec <gregab(at)noviforum(dot)si> |
|---|---|
| To: | mlists <mlists(at)panforma(dot)co(dot)yu> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Postgres and multiprocessor? |
| Date: | 2004-03-08 10:55:20 |
| Message-ID: | 20040308105520.GA4669@elbereth.noviforum.si |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
...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
> computer, and if so, how much will it speed up database server? Tnx in
> advance.
>
> 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 evenly,
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,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Silvana Di Martino | 2004-03-08 12:07:23 | HIPAA |
| Previous Message | mlists | 2004-03-08 10:23:57 | Postgres and multiprocessor? |