pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: chen@musc.edu
Cc: pgsql-admin@postgresql.org
Subject: Re: run httpd and postgresql on different machines ?
Date: Tue, 18 Jan 2005 09:44:50 -0600
Message-ID: <1106063090.23377.5.camel@state.g2switchworks.com> (raw)
In-Reply-To: <41ED10E2.6030502@musc.edu>
References: <41ED10E2.6030502@musc.edu>

On Tue, 2005-01-18 at 07:36, Chuming Chen wrote:
> Hi, all,
> 
> I want to set up a web site using apache httpd, php and postgresql. From 
> the performance point of view, which  architecture is better? 1)  Run 
> httpd and postgresql on the same machine; 2) Run postgresql on seperate 
> machine. My concern is that the machine I am going to run httpd has 
> limitted storage. I am expecting the increasing of postgresql database 
> once I set it ip.
> 
> Any suggestions and comments will be highly appreciated.

It really depends on whether apache/php and postgresql are going to be
fighting for the same resources.  apache/php tends to be CPU intensive,
while PostgreSQL tends to be I/O intensive.  It might be more economical
to simply upgrade the I/O subsystem on the one machine to be bigger and
faster than to build a whole other machine.

On the other hand, setting it up on two machines allows you to configure
each one as the other's fail over so you can improve your reliability
and performance.



view thread (4+ messages)  latest in thread

Message-ID: <1106063090.23377.5.camel@state.g2switchworks.com>
Permalink:  ../1106063090.23377.5.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1106063090.23377.5.camel@state.g2switchworks.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: smarlowe@g2switchworks.com, chen@musc.edu
  Subject: Re: run httpd and postgresql on different machines ?
  In-Reply-To: <1106063090.23377.5.camel@state.g2switchworks.com>
  References: <41ED10E2.6030502@musc.edu> <1106063090.23377.5.camel@state.g2switchworks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox