Greetings, I am looking for feedback on the AMD Opteron based platform as a server for Postgres, and also comments. The databases I am looking at will likely have aggregate sums of indexes larger than the amount of memory on a 32 bit machine, so I am looking at 64-bit platforms.
Does anyone here have experience with use of the Opteron platform? There was a post a while ago by someone asking if it would run on a Beowolf cluster of opterons ( indicated it won't ) but I am interested in knowing if anyone has actually implemented it on an Opteron machine. It should work since Opteron runs linux, but knowing that it _is_ in production somewhere would give me more leverage to get an implementation plan approved. I know that many here have used Sun and IBM to scale postgres but looking at the cost, Opteron is the most attractive right now. The database sizes I am looking at are in the realm of 5-50 gigabytes. So far I have been able to achieve acceptable speeds on a 2 gigabyte database with a 32 bit machine, but as the data size grows an argument has been introduced that going with MySQL would allow us to scale with smaller machines (hold the flames please :). I have optimized and tuned the hardware and database according to the fine advice given on these lists (especially according to the kernel cache/shared buffer cache balancing threads). Comments and suggestions greatly appreciated. Thanks Fred Moyer ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
