From: | peter pilsl <pilsl(at)goldfisch(dot)at> |
---|---|
To: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | optimal hardware for postgres? |
Date: | 2005-04-24 09:01:48 |
Message-ID: | 426B607C.30405@goldfisch.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm just going to buy a new server which will mainly run a
postgreSQL-database and a apache2 with mod_perl and do little more than
deliver loads of index-based select-queries. But it will have to do a
lot of them. And it will be master for a replication to slaves.
As always of course we dont know how many selects we'll have to face.
There will be "many" and the current Athlon1800+ with 1GB Ram is too
slow. (to its excuse : It has to perform loads of other tasks as well)
I was now wondering which hardware would fit this server best. I think
about 2GB RAM, a fast Raid1 and now I'm not sure about the CPU.
I was considering 64-bit AMD : A Athlon 64 FX-51 or a Opteron 2.2GHz.
The hosting system will be a 64-Bit linux.
Does postgres benefit from 64-bit AMD's or would I be better off with a
cheaper AthlonXP or even with a Pentium or a more expensive Xeon?
Or is my question faulty at all, cause CPU is only 20% of the whole system.
Any comments appretiated,
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fae +43 699 4 3574035
pilsl(at)goldfisch(dot)at
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Wiersig | 2005-04-24 10:14:36 | Re: Had a problem with pg_clog |
Previous Message | Ron Mayer | 2005-04-24 05:53:37 | Re: Pgpool questions |