From: Zavier <zavier@zavier.net>
To: pgsql-php@postgresql.org
Subject: Web & DB Servers
Date: Fri, 8 Feb 2002 20:03:13 -0600
Message-ID: <005801c1b10d$f2ab0530$1c2128c4@thinkpad> (raw)
I'm wondering what the better solution is:
Apache/PHP & PgSQL on one physical server with 100% performance (ie. 1200
MHz, 2GB RAM) or have Apache & PgSQL each on a server with half the
performance (600MHz/1GB RAM each).
I'm especially curious in the way long running queries affect the L2 cache
performance in the mixed enviroment. What if Apache & PgSQL are fighting
over the L2 cache making it's large size (in case of the new .13 micron
CPU's from Intel) rather useless compared to the "dedicated solution", where
each CPU runs only one application and can use the cache better? Maybe I'm
missing something here completely, so I would appreciate any
comments/suggestions. Is there a noticable performance gain in splitting the
server in two?
Thanks!
-Zavier
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-php@postgresql.org
Cc: zavier@zavier.net
Subject: Re: Web & DB Servers
In-Reply-To: <005801c1b10d$f2ab0530$1c2128c4@thinkpad>
References: <005801c1b10d$f2ab0530$1c2128c4@thinkpad>
* 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