Thread: sizing of a server

Hi

I would like to create a database server with postgres web application.

My DB size will be 20GB.

I will write 10000 a day with until 10 to 15 simultanous write.

How could I size my server (memory, CPU, ...) ?

Regards

gertrude

---

iFRANCE exprimez-vous !

gpap@ifrance.com wrote:
> I would like to create a database server with postgres web application.
>
> My DB size will be 20GB.
> I will write 10000 a day with until 10 to 15 simultanous write.
> How could I size my server (memory, CPU, ...) ?

The only reliable way is to do some testing. Now 10,000 rows a day isn't
many and I doubt it will be 10-15 simultaneous writes (although it might
be 10-15 simultaneous connections).

The key questions will be how much of that 20GB gets used regularly, and
what level of performance you'll need.

The best way of finding out is to do some testing - use a standard
desktop machine (or laptop) and see how that performs. Make sure you
have a realistic mix and amount of data though.

If I had to guess, I'd buy a cheap server with some SATA disks (at least
2 so you can mirror them) and as much RAM as was left in my budget.

--
   Richard Huxton
   Archonet Ltd

>
> The best way of finding out is to do some testing - use a standard
> desktop machine (or laptop) and see how that performs. Make sure you
> have a realistic mix and amount of data though.
>
> If I had to guess, I'd buy a cheap server with some SATA disks (at least
> 2 so you can mirror them) and as much RAM as was left in my budget.

Yeah, this sounds like a dualcore amd64 with a areca 4 drive sata raid
10 array. Put 2/4 gig of ram in it, and you will think it is just flying.

Joshua D. Drake





--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/