From owner-freebsd-database@FreeBSD.ORG Mon May 29 21:40:00 2006 Return-Path: X-Original-To: freebsd-database@FreeBSD.org Delivered-To: freebsd-database@FreeBSD.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id AE99216B0AC; Mon, 29 May 2006 21:40:00 +0000 (UTC) (envelope-from berend@pobox.com) Received: from stewie.iconz.co.nz (etrn.iconz.co.nz [210.48.22.36]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5731643D58; Mon, 29 May 2006 21:39:24 +0000 (GMT) (envelope-from berend@pobox.com) Received: from localhost (localhost.localdomain [127.0.0.1]) by stewie.iconz.co.nz (Postfix) with ESMTP id 585952B0653; Tue, 30 May 2006 09:39:22 +1200 (NZST) Received: from stewie.iconz.co.nz ([127.0.0.1]) by localhost (stewie [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22740-07; Tue, 30 May 2006 09:39:22 +1200 (NZST) Received: from bmach.nederware.nl (ip-210-185-13-158.internet.co.nz [210.185.13.158]) by stewie.iconz.co.nz (Postfix) with ESMTP id C21882B0105; Tue, 30 May 2006 09:39:21 +1200 (NZST) Received: from dellius.nederware.nl (unknown [203.109.148.19]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by bmach.nederware.nl (Postfix) with ESMTP id 471F922E3B; Tue, 30 May 2006 09:39:20 +1200 (NZST) Received: from dellius.nederware.nl (localhost [127.0.0.1]) by dellius.nederware.nl (Postfix) with ESMTP id 8F8E911D59C; Tue, 30 May 2006 09:39:13 +1200 (NZST) To: Palle Girgensohn References: From: Berend de Boer X-Home-Page: http://www.pobox.com/~berend/ Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAHlBMVEVUJyv///2DT1Wek5z/ ///9/f0uFBTa3OSYam4RBweGhjlLAAACWUlEQVR4nE2TTW/bMAyGCQfV2mOAFbsKapu5tyLqluxY 1EbPRWOkRyEHrboVcwvlWDgN6mOxgzD+25GSP0I4DsDHJPWSIhRsa62b4xNrEcO+SAb8KutdA+Aw 0PP0egDWS2n5c+SQj9UIavYzYMs45KZiUM6FtUC/mMxwlTKBN2sypYCZRTtZ9eDuDVTbto1SSloM xyOYt701wll4KYrTBFo9EOGCuSZfBLe7EUh7AB4+ImgScPa917FlkKcIBdae9+DPxzJG5BG4cDGA 3QgaatlFcfM1AR1rqEilw/20qqoBqGikUuC+7AQ+6iWrBqoLSok0kqhDS2tSpwzkM3vUg7s5dz0C gPzNZtSTmwTYmdFQMGxymuV7Ua0i2FKHLHXWGqXyxsijMp3qdiuFMFwdspyUqPMe1HMJ0J235VRl dZ9Ao1Tvb5uMakzTqWruh2pUGiRkPzrlpdetbFWuZhBTqdcBLOljRXVYuTJnVQeKugEjSAs/xL8U PdhKMHSrgrUBMgnXw018JB2OLmGwSD2D1QAeuBvIKIKXQ+CQGmjRGSM2I/gmnQtUVgRBM9mMNdZS GC6NPBT3eQBmlJqzSwrAz+/jRl0Z4N6SBl6ds9cR8GjZeHvCxFcdKJ5pqDxw4CObhfdpgnTetDIg WMrE+6U4TmAtAnfERI27xRWtaQLljA/LS4j4qTX9uQ48O9ctLU70T35DFe1h8FPAJdfpQHXVgzOt Ef95D9PTCOqT5N9ozrSIYEps7VNI2Gn9C/96BtPpfVV5f4mkhSprfYK/O3BK/hpRCvtEfh0z+f9V 9W42shhvowAAAABJRU5ErkJggg== Date: Tue, 30 May 2006 09:39:13 +1200 In-Reply-To: (Palle Girgensohn's message of "Mon, 29 May 2006 17:44:02 +0200") Message-ID: <874pz8mry6.fsf@dellius.nederware.nl> User-Agent: Gnus/5.1006 (Gnus v5.10.6) Emacs/21.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new-20030616-p10 (ICONZ) at stewie.iconz.co.nz Cc: freebsd-database@FreeBSD.org, postgresql-admin@postgresql.org Subject: Re: Suggestion for a very fast postgresql machine? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 29 May 2006 21:40:12 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Palle Girgensohn 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 iD8DBQFEe2oAIyuuaiRyjTYRAu5qAJ9qMmePI/BkJNr8vZ2oNFIN2wmRAQCcDTpU rN1BSk7tK402DXd2IsH3Fj4= =mZSY -----END PGP SIGNATURE-----