Date: Tue, 30 May 2006 09:39:13 +1200 From: Berend de Boer <berend@pobox.com> To: Palle Girgensohn <girgen@FreeBSD.org> Cc: freebsd-database@FreeBSD.org, postgresql-admin@postgresql.org Subject: Re: Suggestion for a very fast postgresql machine? Message-ID: <874pz8mry6.fsf@dellius.nederware.nl> In-Reply-To: <D542F1895C3EAEC10F102B03@rambutan.pingpong.net> (Palle Girgensohn's message of "Mon, 29 May 2006 17:44:02 %2B0200") References: <D542F1895C3EAEC10F102B03@rambutan.pingpong.net>
next in thread | previous in thread | raw e-mail | index | archive | help
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Palle Girgensohn <girgen@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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?874pz8mry6.fsf>