Jean,
We are using a quad pentium xeon machine with 6 GB ram RH 7.1 enterprise
kernel. Postgres uses everything that is available. Actually, its only
idling with the hardware we have and we have tables with over 2M rows.
Your disk subsystem is very important as well as it can easily become a
bottleneck that can cripple an otherwise capable system. We have placed
our largest and most active tables as well as indices on separate
physical drives for best performance.
Jean Huveneers wrote:
>
> Hi,
>
> Within an couple of weeks we will start using PostgreSQL on Mandrake 8.1
> in real business (we have been testing, for over a half year).
>
> In future we will have some tables with 100.000+ records an the system
> has te work very fast.
>
> I know that speed of querries depend much on the amount of availible RAM
> to PostgreSQL, the server will only run the databases. What amount is
> RAM is usefull (I meen, does Postgres use the RAM, if availible, up to 2
> GB)?
>
> I'm can chose for a Dual Athlon MP on a Tyan Thunder K7 motherbord, but
> does PostgreSQL use the 2 processors?
>
> Regards,
>
> Jean Huveneers
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Bill MacArthur
Webmaster
DHS Club