Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B72FC632D98 for ; Wed, 3 Feb 2010 12:19:49 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 46206-04 for ; Wed, 3 Feb 2010 16:19:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay-7.dlfw.twtelecom.net (relay-7.dlfw.twtelecom.net [216.136.82.76]) by mail.postgresql.org (Postfix) with ESMTP id 1A74663358D for ; Wed, 3 Feb 2010 12:19:39 -0400 (AST) Received: from localhost (unknown [127.0.0.1]) by relay-7.dlfw.twtelecom.net (Postfix) with ESMTP id B7B605808F for ; Wed, 3 Feb 2010 09:19:35 -0700 (MST) X-Virus-Scanned: amavisd-new at twtelecom.net Received: from relay-7.dlfw.twtelecom.net ([127.0.0.1]) by localhost (relay-7.dlfw.twtelecom.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id XqCHvJPkLAtV for ; Wed, 3 Feb 2010 09:19:33 -0700 (MST) Received: from mailblocker.ateb.com (unknown [97.65.140.200]) by relay-7.dlfw.twtelecom.net (Postfix) with ESMTP id E850E5807E for ; Wed, 3 Feb 2010 09:19:32 -0700 (MST) X-IronPort-AV: E=Sophos;i="4.49,399,1262581200"; d="scan'208";a="6074420" Received: from unknown (HELO sr002-2k3exc.ateb.com) ([172.16.48.228]) by mailblocker.ateb.com with SMTP; 03 Feb 2010 11:19:32 -0500 Received: from 172.16.48.3 ([172.16.48.3]) by sr002-2k3exc.ateb.com ([172.16.48.228]) with Microsoft Exchange Server HTTP-DAV ; Wed, 3 Feb 2010 16:19:32 +0000 Received: from raker by sr002-2k3exc.ateb.com; 03 Feb 2010 11:19:32 -0500 Subject: Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes From: Reid Thompson Reply-To: reid.thompson@ateb.com To: Amitabh Kant Cc: reid.thompson@ateb.com, pgsql-performance@postgresql.org In-Reply-To: <84b68b3d1002030712j6fab33b8xe1d0f1071d207bcb@mail.gmail.com> References: <84b68b3d1002030710x76c31adft58c56624409011fd@mail.gmail.com> <84b68b3d1002030712j6fab33b8xe1d0f1071d207bcb@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Organization: Ateb, Inc Date: Wed, 03 Feb 2010 11:19:32 -0500 Message-ID: <1265213972.30463.1.camel@raker.ateb.com> Mime-Version: 1.0 X-Mailer: Evolution 2.29.90 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.687 tagged_above=-10 required=5 tests=AWL=-0.577, BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201002/62 X-Sequence-Number: 37483 On Wed, 2010-02-03 at 20:42 +0530, Amitabh Kant wrote: > Forgot to add that I am using Postgres 8.4.2 from the default ports of > FreeBSD. start with this page http://www.postgresql.org/docs/8.4/static/kernel-resources.html