Skip site navigation (1) Skip section navigation (2)

Re: smp , php and postmaster distant

From: Chris Albertson <calbertson(at)logicon(dot)com>
To: Dana Hudes <dhudes(at)hudes(dot)org>
Cc: Loïc TREGOUËT <loic(at)ext(dot)cri74(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: smp , php and postmaster distant
Date: 2000-06-22 18:28:28
Message-ID: 39525ACC.E50F258C@logicon.com (view raw or flat)
Thread:
Lists: pgsql-admin
Dana Hudes wrote:
<snip>
> 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.

The above is correct, but Postgresql uses one process per connection.
This is a (possibly crude) from for multi threading.  But it is the same
way the web server works.  The process is forked.  In the systems I've seen
it is common to have four to eight simultaneous open connections to
the database.  Multiple CPUs _do_ help in this case.

The question below is hard to answer.  If I read it correctly he is asking
"Why is performance go down when I switched to a dual CPU system?"  He does
not provide detailed information about the configuration of his system both
before and after the change so we can't answer.  Perhaps he had fsync disabled
then but no now.  Who knows?  A lot more detail is required.

My point is one more that with Postgresql, multiple CPUs can help if you have
multiple active clients.

> > 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

-- 
  Chris Albertson

  calbertson(at)logicon(dot)com                  Voice: 626-351-0089  x17
  Logicon, Pasadena California            Fax:   626-351-0699

In response to

pgsql-admin by date

Next:From: L. Scott LoftinDate: 2000-06-23 17:59:02
Subject: Importing massive amounts of data into a PostgreSQL database
Previous:From: Dana HudesDate: 2000-06-22 18:02:17
Subject: Re: smp , php and postmaster distant

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group