Re: smp , php and postmaster distant

to my knowledge PostgreSQL is not multi-threaded.
PHP appliations don't support threads or multiple processes; Perl supports multiple processes and, especially in 5.6
(andsome development 
versions before it) threads.
Your gain from SMP under such situation is the application has a cpu for itself
and all the system overhead processes run on the other cpu.

I think PgSQL is thread-safe but someone like Bruce Momjian would know for sure.


----- Original Message -----
From: "Loïc TREGOUËT" <loic@ext.cri74.org>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, June 22, 2000 1:50 PM
Subject: [ADMIN] smp , php and postmaster distant


> Hie ,
>
>
>     I have put a database on a 2 processors db server . (2 * PII 450 Mhz
> with 512 Mo RAM)
>
>     This server is distant from the web server .
>
>     I've a php3 interface and , i've seen some big loose of performance
> .
>
>     The request are longer when i use the bi-processor .
>
>     Is it due to the distant server or do i need some configurations to
> postmaster to accept multi prcocessors ?
>
>     The web server and the database server are link with a 100Mbit link
> !
>
>                                                             thanks for
> all