X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 815D2D1B51F for ; Fri, 27 Feb 2004 03:12:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95923-09 for ; Thu, 26 Feb 2004 23:12:28 -0400 (AST) Received: from mxsf01.cluster1.charter.net (mxsf01.cluster1.charter.net [209.225.28.201]) by svr1.postgresql.org (Postfix) with ESMTP id 9AA57D1B4AA for ; Thu, 26 Feb 2004 23:12:23 -0400 (AST) Received: from turbocorp.com (66-168-202-107.cpe.ga.charter.com [66.168.202.107]) by mxsf01.cluster1.charter.net (8.12.10/8.12.8) with ESMTP id i1R37oio020919; Thu, 26 Feb 2004 22:07:50 -0500 (EST) (envelope-from john@turbocorp.com) Message-ID: <403EB485.10802@turbocorp.com> Date: Thu, 26 Feb 2004 22:07:49 -0500 From: John Allgood User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: josh@agliodbs.com Cc: pgsql-performance@postgresql.org Subject: Re: Database Server Tuning References: <200402262128.i1QLS4VD023380@mxsf20.cluster1.charter.net> <200402261448.34352.josh@agliodbs.com> In-Reply-To: <200402261448.34352.josh@agliodbs.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/312 X-Sequence-Number: 5836 Josh Berkus wrote: >John, > > > >>and Postgres server runtime parameters and other settings relating to >>tuning. Also is there any benchmarking tools available that will help me >>tune this server. >> >> > >Check out >http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > >Also, I'd like to see what you get under heavy load for context-switching. >We've been having issues with RH+Xeon with really large queries. > > > This is exactly what I was looking for. I will keep you posted on what kinda results I get when I start putting a load on this server. Thanks John Allgood - ESC Systems Administrator 770.535.5049