On Thu, 26 Aug 1999, Michael wrote:
> Hi
>
> I am about to upgrade a server that is about to be running a large and busy
> postgresql database
> currently it has
>
> 128 MB 100 MHz SDRAM
> AMD K6-2/300 CPU
> 10 GB 7200RPM 9.0ms IBM IDE HDD
>
From experience I'd say the biggest performance increase would be to get
away from the IDE HD. It is also the first or second most expensive
portion of your plan.
RAM will help but not that much when it comes to disk accesses. It should
provide a certain amount of cache for the disk subsystem but teh bottle
neck will still be the the IDE interface. (Though I've seen some IDE
controllers with onboard cache.)
> It will, over the next few months, as money becomes available, be upgraded to:
Depending on how fast the money trickles in you'd get some help cheapest
with the RAM, then the SCSI, then the MB and processors.
Rod
--
Roderick A. Anderson
raanders@altoplanos.net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814