Thread: multi processor

            Hello ,

Maybe my question is stupid but , i can't test it .

Is Postgresql , can use more than one processor for one request or is
depend of something else ?

    thanks

P.S:If someone give me a multi-processor computer , i could make the
test and you will not have to reply to me ! No ?

I think Postgres won't do anything to handle multiple processors. Since you have one Postgres process per DB
connection,multiples active connections will be spread around your processors, and the overall speed will be increased,
justlike any other software on an SMP machine with an SMP system. 

Nicolas Huillard

-----Message d'origine-----
De:    Loïc TREGOUËT [SMTP:loic@ext.cri74.org]
Date:    vendredi 9 juin 2000 15:06
À:    pgsql-admin@postgresql.org
Objet:    multi processor

            Hello ,

Maybe my question is stupid but , i can't test it .

Is Postgresql , can use more than one processor for one request or is
depend of something else ?

    thanks

P.S:If someone give me a multi-processor computer , i could make the
test and you will not have to reply to me ! No ?

Loïc TREGOUËT writes:

> Is Postgresql , can use more than one processor for one request or is
> depend of something else ?

PostgreSQL is at the mercy of your operating system regarding SMP. In many
cases this means that the smallest granularity is at the process level, so
one connection per processor.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

Loïc TREGOUËT writes:

> Is Postgresql , can use more than one processor for one request or is
> depend of something else ?

Not if your operating system doesn't support multiple processors per one
(single-thread) process. Most don't. What you'll most likely end up with
is one processor per process, that is, connection.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden