Suggestion for a very fast postgresql machine?

[Berend de Boer]

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

Palle Girgensohn <girgen at FreeBSD.org> writes:


> I'm thinking in terms of at least four CPU:s, 12 GB RAM. Hardware is
> mostly a matter of money, I guess, and disks are probably the
> bottleneck, right? 

Only when you're writing a lot. If only 100MB of your 11 GB database
is queried, disks don't matter. With 12GB or RAM, if FreeBSD +
PostgreSQL can use all that, your entire database is possibly in
memory. If you're only reading and not writing a lot, disks are
important, but not that important.

- -- 
Live long and prosper,

Berend de Boer
(PGP public key: http://www.pobox.com/~berend/berend-public-key.txt)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.8 <http://mailcrypt.sourceforge.net/>

iD8DBQFEe2oAIyuuaiRyjTYRAu5qAJ9qMmePI/BkJNr8vZ2oNFIN2wmRAQCcDTpU
rN1BSk7tK402DXd2IsH3Fj4=
=mZSY
-----END PGP SIGNATURE-----