X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 057559DC8A2 for ; Fri, 24 Feb 2006 23:42:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56356-02 for ; Fri, 24 Feb 2006 23:42:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from candle.pha.pa.us (candle.pha.pa.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 53F169DCA35 for ; Fri, 24 Feb 2006 23:42:33 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id k1P3gdj15861; Fri, 24 Feb 2006 22:42:39 -0500 (EST) From: Bruce Momjian Message-Id: <200602250342.k1P3gdj15861@candle.pha.pa.us> Subject: Re: In-Reply-To: <20060223202905.GQ86022@pervasive.com> To: "Jim C. Nasby" Date: Fri, 24 Feb 2006 22:42:39 -0500 (EST) CC: Vivek Khera , Postgresql Performance X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.387 required=5 tests=[AWL=-0.113, RAZOR2_CHECK=0.5] X-Spam-Score: 0.387 X-Spam-Level: X-Archive-Number: 200602/400 X-Sequence-Number: 17386 See the FAQ. --------------------------------------------------------------------------- Jim C. Nasby wrote: > On Thu, Feb 23, 2006 at 09:38:25AM -0500, Vivek Khera wrote: > > > > On Feb 22, 2006, at 10:44 PM, Chethana, Rao ((IE10)) wrote: > > > > >That is what I wanted to know, how do I tune it? > > > > If there were a simple formula for doing it, it would already have > > been written up as a program that runs once you install postgres. > > > > You have to monitor your usage, use your understanding of your > > application, and the Postgres manual to see what things to adjust. > > It differs if you are CPU bound or I/O bound. > > > > And please keep this on list. > > FWIW, had you included a bit more of the original post others might have > been able to provide advice... but now I have no idea what the original > question was (of course a blank subject doesn't help either... no idea > where that happened). > > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +