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