>
> 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 the same
> database(s). I get lots and lots of queries, and it's just too much for one
> poor machine to handle.
Is this really true? "too much for one poor machine to handle"?
Could you be more specific?
1) What kind of hardware are you using. What CPU(s), how fast?
How much RAM?, What kind of disk(s) (RAID?) and so on.
2) How big is your task? How many rows and tables. How many
queries per minute? Do you do many big joins?
I think Postgres scales well if you throw hardware at at. I wonder
if you've tried that yet.
All that said, I'd be very much interrested in Distribution and
replication for another reason. I am working with a large database.
(on order of a hundred million rows) Our application is distributed
over the (much to slow) Internet. The ability to periodically
synchronize servers would work for us.
PS Please cc any reply to me directly as a get the digest.
--
Chris Albertson
[EMAIL PROTECTED] Voice: 626-351-0089 X127
Logicon, Pasadena California Fax: 626-351-0699
************
