Re: PostgreSQL HardWare

> I think your hardware is  overkill.  Any low end
> box would work for you. But if you have MANY users trying
> to query this data all at once the hardware may be needed.
> I don't think you need that Second CPU _unless_ you plan
> for many concurent client conections or if the server will
> be performing other services (apache, mail, NFS....) at the
> same time.

  Adding a second CPU to a machine you're building yourself costs a
(relatively) very small amount of money, but nearly doubles the capacity
of the machine, and greatly extends it's useful lifetime.  I think that
the benefits far outweigh the cost - adding a second CPU may add 20% (or
less) to the cost of the machine, but get you an 80% increase in capacity.

  As an example, I have an old dual Pentium-133 that I picked up for $40.
Comparing it to using a machine with a single 650 MHz P3, the little
machine is usually MORE responsive, and always at least nearly as
responsive.  Very CPU-intensive apps do take longer, but overall the
machine is extremely pleasant to work on.  When you compare the
significant performance difference between a Pentium 133 and a P3/650, I
think that says a LOT about the merits of multi-processor systems.  For
production servers, it's a pretty rare day when I wouldn't fork over $40
more for a dual CPU board, and buy a second processor.  Or, if money was
tight, I'd buy the board, and get the second CPU in a month or two. : )

  (And, hey, the first time you see a PCI device using IRQ 27, it makes
you take a double-take!)

steve