-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/08/07 14:04, MaRCeLO PeReiRA wrote: > Hi there, > > Actually my PostgreSQL server is running on a Athlon > XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard. > > I would like to buy a new server, could you please > give me some information about the specs?? > > Is it important to have a Dual (or even Quad) > processor??? Will PostgreSQL use them?? > > What about memory??? How much??? > > SCSI Disks and 10/100/1000 netcards, it's ok!! No > doubt! > > It's a medium use server, about 3000 transactions/day. Presumably in the 10 hours from 08:00 to 18:00? If so, that's: 300 txn/hr 5 txn/minute 0.08333 txn/sec. Your existing server can handle that. Is there something you aren't telling us? Is the system 99.99% SELECTs? That would be 30,000,000 SELECTS/day. Obviously a burden to any but the biggest systems. Are your tables indexed properly for the given queries? More hw won't solve crappy/non-existent index support How complicated are the queries? Simple and low volume, or 15 table OLAP mega-joins? For that matter, how complicated are the transactions? Does each INSERT trigger 18 UPDATEs and 10 DELETEs? None of which have proper index support? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGQNHbS9HxQb37XmcRAicrAJ4740CpjG4jERQnW/ta0VkhjR++RQCg4r3g BRAWEy4mdnyKJzjehluGbb4= =HbGC -----END PGP SIGNATURE-----
