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