Re: PostgreSQL HardWare

don't forget to check ebay out - they have a lot of decent deals from
the recent dot-bomb fallout. i got a dell 4350 w/ dual PIII 600's,
3x18gb scsi (raid 5), raid controller, 1gb ram, 3 hot-swap power
supplies, 4 hot swap fans, etc. for under $2000 including shipping.

rjsjr

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of SHELTON,MICHAEL
> (Non-HP-Boise,ex1)
> Sent: Friday, January 04, 2002 1:42 PM
> To: 'Fernando San Martín Woerner'; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] PostgreSQL HardWare
>
>
> In my last job we ran a multi-tiered online futures and options trading
> system. Our database was originally on a 2 processor system. What was
> interesting was when we ran tests we decided to try a single processor
> system and found that the performance was only marginally (1-2%) better on
> the 2 processor system. So for future upgrades we spent the extra cash on
> the fastest single processor we could find rather than on 2
> processors. We
> never tested for 4 or more processors so I can't comment on the
> performance
> issues there, but my 2 cents would be to spend the extra money on a faster
> processor (if you even need to -- maybe save the money altogether!).
>
> Mike Shelton
>
> -----Original Message-----
> From: Fernando San Martín Woerner [mailto:snmartin(at)galilea(dot)cl]
> Sent: Friday, January 04, 2002 7:39 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] PostgreSQL HardWare
>
>
> I need to build a postgresql database with 2 tables containing 70.000
> records each one, but they'll increase their size in 4.000 records monthly
> and some triggers and functions will be running on this tables plus other
> smaller tables less than 40.000 records.
>
> So i'm planning to implement a Intel PentiumIII Server with 2 cpu, 1GB RAM
> and a SCSI HDD with 10 GB running red hat 7.2.
>
> will be enough? have you experiences about it? some tips?
>
>
> thanks and happy new year....
>
>
>
> Fernando San Martín Woerner counter.li.org Linux User #216550
> Jefe Depto. Informática Galilea S.A.
> Talca, VII Región Chile (56)71-224876
> ----------------------------------------
> Si hubiera previsto las consecuencias me hubiera hecho relojero.
>
> Albert Einstein
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>