By "typical machine", I tought about "the one you have" : just tell me what you
actually take out of your server, whatever it is : number of queries per day or CPU
load vs. CPU type/speed + RAM amount.
What does your Ultra Sparc ? What is it's main characteristics ? I knwo this is not a
benchmark, and I don't want anyone to mesure exact bench : I just want to have an idea
of what people do.
Do you have an idea of what can do a quad Xeon 500Mhz with 1-4GB RAM/10000RPM disks ?
TIA,
Nicolas Huillard
-----Message d'origine-----
De: Chris Albertson [SMTP:[EMAIL PROTECTED]]
Date: mardi 14 mars 2000 21:55
�: Nicolas Huillard
Objet: Re: [ADMIN] High load postgres-driven Web sites
Nicolas Huillard wrote:
>
> Have someone experience about high-load web sites, using Postgres/mod_perl-Mason ?
>
> The facts :
> * each Apache server has it's database connections (i'm using Mason, which is a
>mod_perl "application server")
> * the database can be on the same machine, or better, somewhere else
> * there may be several Apche machines using a single database
> * each connection to the database is a postgres process, using a fair amount of
>memory
> * if I host many sites, the database machine will have many * many database processes
> The questions :
> * how many database connections can be shared this way, on a typical machine
>(CPU/RAM)
What is a "typical machine"? I have Postgres installed on a notebook computer
running
Linux and on a much bigger Sun Ultra SPARC under Solaris 7.
If your bussinees depends on your
database and your bussiness can afford office space, a payroll,
insurance and so on I'd think it could afford a decent computer. That means
one that can handle the load - whatever it may be.
You should be looking at 1 to 4 GB of RAM, a RAID system with 10,000RPM LVD SCSI
disks and maybe four or eight way SMP with either Xeon, SPARC or Alpha
processors.
(I've found that the Xeons with the larger 1MB L2 cache realy are better for
multi
processor systems.)
--
Chris Albertson
[EMAIL PROTECTED] Voice: 626-351-0089 X127
Logicon, Pasadena California Fax: 626-351-0699
