X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id B69B6CC44F for ; Tue, 15 Jul 2003 18:04:36 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 60196-06 for ; Tue, 15 Jul 2003 18:04:54 +0000 (GMT) Received: from yertle.kcilink.com (yertle.kcilink.com [216.194.193.105]) by svr1.postgresql.org (Postfix) with ESMTP id 5ECBDCB571 for ; Tue, 15 Jul 2003 15:04:25 -0300 (ADT) Received: by yertle.kcilink.com (Postfix, from userid 100) id D36C62178A; Tue, 15 Jul 2003 14:04:54 -0400 (EDT) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16148.16966.755692.737018@yertle.int.kciLink.com> Date: Tue, 15 Jul 2003 14:04:54 -0400 To: "Stephen Howie" Cc: Subject: Re: Tunning FreeeBSD and PostgreSQL In-Reply-To: <005e01c34af4$9578e670$c40712ac@showie> References: <012701c34a14$9b60ce80$c40712ac@showie> <200307141702.25620.dev@archonet.com> <017201c34a2c$a4fd5c70$c40712ac@showie> <005e01c34af4$9578e670$c40712ac@showie> X-Mailer: VM 7.14 under 21.4 (patch 12) "Portable Code" XEmacs Lucid X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/235 X-Sequence-Number: 2528 >>>>> "SH" == Stephen Howie writes: SH> Vivek, SH> Thanks, for your reply. May I ask what you system setup is like (i.e. SH> memory and such)? Current box is dual P3 1GHz and 2GB RAM. RAID0+1 on 4 disks. I'm about to order a bigger box, since I'm saturating the disk bandwidth as far as I can measure it. I'm thinking along the lines of 8 disks on RAID0+1 and 4GB RAM. The CPUs twiddle their thumbs a lot, so no point in really beefing that up.