Dream Server?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm currently running a 4 Gig 11 million row database and am looking
to build a "dream server" for it. I am currently running a dual p3
1GHz system with 10k rpm scsi drives and 4 gigs of ram (which I have
configured pgsql to use all of) and I'm concerned about performance
once the db doubles in size, which should be in 6 mos to a year at
the latest. First off, If money was no concern, what would you buy
as the ultimate postgresql server running linux? Second off, on a
more technical note, does pgsql take advantage of multiple
processors. If I had a 8 way 800 MHz Xeon would the machine blow
away a 2GHz P4? How much is CPU a factor compared to memory? Disk
speed? I want to be able to do large volume selects on tables with
more than 5 million rows and not have the server blink at other
requests put in at the same time.

Any hints or suggestions/experience here would be appreciated.

Thanks,

Gavin

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPGGlgn9xeBXAlKqsEQJPywCfenV2bHDKJ0czKLy2qbaoj+hiow8AoNaT
9gYOTvmzFR9+YIjA5MQwjSMN
=B6Ak
-----END PGP SIGNATURE-----