> I guess i'm pretty ignorant about big expensive servers. Is the
> 450 really that much faster than say a few Dual PIII's? I guess if I can
> buy 10 Dual PIII for the price of one 450, I'd have a pretty hard time
> buying the 450. I feel like no matter how big a server I buy, I will
> eventually
I'm glad someone asked this, because I'd like to try and optimize my
database or the way I'm using it, and I've reached my personal limit on
optimization at this point.
1) I'm using two machines so far for my e-comerce solution. The website is
usedcars.com, in case you want to go and check the pe
> > It sounds to me like the "throw hardware at the problem" solution
> > is not even close to exhausted yet. You are still using petty low
> > cost equipment. Run the "top" program in an xterm on the database
> > server when the system is loaded. What do you see? Is the CPU at
> > 100%? How
You are doing both a "join" and a "union". The join is the part
where you go "a.oid = b.id".
It sounds to me like the "throw hardware at the problem" solution
is not even close to exhausted yet. You are still using petty low
cost equipment. Run the "top" program in an xterm on the database
ser
>
> Date: Thu, 28 Oct 1999 01:11:32 -0700
> From: Rich Ryan <[EMAIL PROTECTED]>
> Subject: HSA (Highly Scalable Architecture) Distribution and replication
>
> Has anyone written a HSA e-commerce solution using postgres? In english,
> this means I want more than one server running postgres with t
for clustered server architecture, check out TurboLinux Cluster Server
(http://beta.turbolinux.com/cluster/). it's in its last beta stages now. we're learning
both postgres and turbocluster; postgres can't handle the distributed architecture
right
now (locks in shared memory = single-cpu), but ho
