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 (and some 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(at)ext(dot)cri74(dot)org>
To: <pgsql-admin(at)postgresql(dot)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