I ran some performance test on a system with ~100k records in each
of several primary tables. The system was being used both as a db host
and as a host for the testing applications (it was just my home system).
It was a PIII 1 Ghz, 256 (maybe 400 at the time) MB Ram, IDE disk. It
performed very well ... maxing out at some very respectible number of
inserts and selects per second. I don't recall the exact statistics but
I posted all that info to the list so you should be able to find it in
the archives (around september or november of 2001).
It also scaled without problem once the appropriate indices were in place
(this is very important ... performance will really hurt without it). I
wasn't doing any extremely complicated queries.
I had no triggers but most tables had one or two foreign keys on them.
I think your configuration will be fine.
Regards,
Sheer
On Fri, 4 Jan 2002, [iso-8859-1] Fernando San Mart�n Woerner wrote:
> 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
>