From owner-freebsd-database@FreeBSD.ORG Mon May 29 15:44:41 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 DA65216AF7A for ; Mon, 29 May 2006 15:44:41 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from banan.pingpong.net (banan.pingpong.net [213.136.40.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3B69143D46 for ; Mon, 29 May 2006 15:44:30 +0000 (GMT) (envelope-from girgen@FreeBSD.org) Received: from rambutan.pingpong.net (rambutan.pingpong.net [192.168.1.187]) by banan.pingpong.net (8.13.6/8.13.6) with ESMTP id k4TFi2Ji002974; Mon, 29 May 2006 17:44:02 +0200 (CEST) (envelope-from girgen@FreeBSD.org) Received: from localhost (localhost [127.0.0.1]) by rambutan.pingpong.net (8.13.6/8.13.6) with ESMTP id k4TFi2P0061360; Mon, 29 May 2006 17:44:02 +0200 (CEST) (envelope-from girgen@FreeBSD.org) Date: Mon, 29 May 2006 17:44:02 +0200 From: Palle Girgensohn To: postgresql-admin@postgresql.org, freebsd-database@FreeBSD.org Message-ID: X-Mailer: Mulberry/3.1.6 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: Subject: 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 15:44:52 -0000 Hi! Do you have any suggestions for building a really fast machine with the sole purpose of running postgresql for a multi user application? The database currently has a 11 GB footprint on the disk. 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? We are currently a FreeBSD only shop, we have very good knowledge about that system, and no experience with Linux. Still, is FreeBSD 6.1 a good choice, or will a Linux distribution outperform for 4+ SMP? I won't have much time to experiment, unfortunately, but I'd love some pointers or tips. Thanks Palle From owner-freebsd-database@FreeBSD.ORG Mon May 29 17:05:16 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 26E1116AE26 for ; Mon, 29 May 2006 17:05:16 +0000 (UTC) (envelope-from nomadlogic@gmail.com) Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id B902E43D76 for ; Mon, 29 May 2006 17:05:12 +0000 (GMT) (envelope-from nomadlogic@gmail.com) Received: by wx-out-0102.google.com with SMTP id i31so161562wxd for ; Mon, 29 May 2006 10:05:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=T8z7fIpGy9LUp6kBLf6T+8f7Gk7S2/8+nKZOSHhHxChjZIEQSlRKLGVJ+gG4Jpk4GjL+sVX7QRCaizKV5k1rYHkVbYgdsDTNM68fG5w2eIYZO7RxuRpbb8aVjnQuzntot8m4uYGo1QICtzVOvmp+uvqVBRlI5fAJDHYvJIOHRsc= Received: by 10.70.6.1 with SMTP id 1mr2541968wxf; Mon, 29 May 2006 10:05:12 -0700 (PDT) Received: by 10.70.83.15 with HTTP; Mon, 29 May 2006 10:05:12 -0700 (PDT) Message-ID: <57d710000605291005o2cf56f9ah2067928054c70cf3@mail.gmail.com> Date: Mon, 29 May 2006 10:05:12 -0700 From: "pete wright" To: "Palle Girgensohn" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: 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 17:05:16 -0000 On 5/29/06, Palle Girgensohn wrote: > Hi! > > Do you have any suggestions for building a really fast machine with the > sole purpose of running postgresql for a multi user application? The > database currently has a 11 GB footprint on the disk. > > I'm thinking in terms of at least four CPU:s, 12 GB RAM. Hardware is most= ly > a matter of money, I guess, and disks are probably the bottleneck, right? > We are currently a FreeBSD only shop, we have very good knowledge about > that system, and no experience with Linux. Still, is FreeBSD 6.1 a good > choice, or will a Linux distribution outperform for 4+ SMP? I won't have > much time to experiment, unfortunately, but I'd love some pointers or tip= s. it really depends on they type of load you will be putting Postgres through. Alot of read only query's, transactions...how many connections at a time hitting it. etc. you should really figure out the answers to these questions before spending money on hardware. generally speaking, disk I/O will be an important bottleneck to consider. If at all possible I would use SCSI or Fiber storage devices in a RAID'd configuration (preferably from a hardware RAID controller with ample cache and a BBU). seriously though, let us know the load profile you expect on this DB then maybe we can give you useful info... -p --=20 ~~o0OO0o~~ Pete Wright www.nycbug.org NYC's *BSD User Group 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----- From owner-freebsd-database@FreeBSD.ORG Tue May 30 18:20:22 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 55D5616A707 for ; Tue, 30 May 2006 18:20:22 +0000 (UTC) (envelope-from david@elvis.mu.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id E3E3943D5C for ; Tue, 30 May 2006 18:20:21 +0000 (GMT) (envelope-from david@elvis.mu.org) Received: by elvis.mu.org (Postfix, from userid 1061) id C4BF91A4DFC; Tue, 30 May 2006 11:20:21 -0700 (PDT) Date: Tue, 30 May 2006 11:20:21 -0700 From: David Drum To: freebsd-database@FreeBSD.org Message-ID: <20060530182021.GA90389@elvis.mu.org> Mail-Followup-To: David Drum , freebsd-database@FreeBSD.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i Cc: 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: Tue, 30 May 2006 18:20:25 -0000 Quoth Palle Girgensohn: > Do you have any suggestions for building a really fast machine with the > sole purpose of running postgresql for a multi user application? Hopefully you have recompiled the kernel to support userland processes larger than 512MB. Regards, David Drum david@mu.org -- "Penultimate." Ooh! Second-best word ever!--Frazz