From vivek@khera.org Thu Feb  23 14:38:25 2006
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 95E149DC9A1
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Feb 2006 10:38:25 -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 62792-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Feb 2006 10:38:28 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180])
	by postgresql.org (Postfix) with ESMTP id A9E7A9DC806
	for <pgsql-performance@postgresql.org>;
	Thu, 23 Feb 2006 10:38:22 -0400 (AST)
Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103])
	by yertle.kcilink.com (Postfix) with ESMTP id CAB0BB80D
	for <pgsql-performance@postgresql.org>;
	Thu, 23 Feb 2006 09:38:26 -0500 (EST)
Mime-Version: 1.0 (Apple Message framework v746.2)
In-Reply-To: 
 <544485BC51F81A41AC1A72CFA69013655640AF@AZ18EV805.global.ds.honeywell.com>
References: 
 <544485BC51F81A41AC1A72CFA69013655640AF@AZ18EV805.global.ds.honeywell.com>
Content-Type: multipart/alternative; boundary=Apple-Mail-1--810451207
Message-Id: <62FC5203-3162-4ABE-BF47-DFE0116AC520@khera.org>
From: Vivek Khera <vivek@khera.org>
Subject: Re: 
Date: Thu, 23 Feb 2006 09:38:25 -0500
To: Postgresql Performance <pgsql-performance@postgresql.org>
X-Mailer: Apple Mail (2.746.2)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.062 required=5 tests=[AWL=0.061,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.062
X-Spam-Level: 
X-Archive-Number: 200602/367
X-Sequence-Number: 17353


--Apple-Mail-1--810451207
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	delsp=yes;
	format=flowed


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.


--Apple-Mail-1--810451207
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=ISO-8859-1

<HTML><BODY style=3D"word-wrap: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space; "><BR><DIV><DIV>On Feb 22, 2006, =
at 10:44 PM, Chethana, Rao ((IE10)) wrote:</DIV><BR =
class=3D"Apple-interchange-newline"><BLOCKQUOTE type=3D"cite"><SPAN =
class=3D"Apple-style-span" style=3D"border-collapse: separate; =
border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Georgia; =
font-size: 14px; font-style: normal; font-variant: normal; font-weight: =
normal; letter-spacing: normal; line-height: normal; text-align: auto; =
-khtml-text-decorations-in-effect: none; text-indent: 0px; =
-apple-text-size-adjust: auto; text-transform: none; orphans: 2; =
white-space: normal; widows: 2; word-spacing: 0px; "><P =
class=3D"MsoNormal"><FONT size=3D"2" color=3D"navy" face=3D"Arial"><SPAN =
style=3D"font-size: 10.0pt;font-family:Arial;color:navy; color: rgb(0, =
0, 128); font-size: 13.3333px; "><SPAN class=3D"Apple-style-span" =
style=3D"color: rgb(0, 0, 128); font-family: Arial; font-size: =
13.3333px; ">That is what I wanted to know,=A0 how do I tune =
it?</SPAN><O:P style=3D"color: rgb(0, 0, 128); font-family: Arial; =
font-size: 13.3333px; =
"></O:P></SPAN></FONT></P></SPAN></BLOCKQUOTE><BR></DIV><DIV>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.</DIV><DIV><BR =
class=3D"khtml-block-placeholder"></DIV><DIV>You have to monitor your =
usage, use your understanding of your application, and the Postgres =
manual to see what things to adjust.=A0 =A0It differs if you are CPU =
bound or I/O bound.</DIV><DIV><BR =
class=3D"khtml-block-placeholder"></DIV><DIV>And please keep this on =
list.</DIV><DIV><BR class=3D"khtml-block-placeholder"></DIV></BODY></HTML>=

--Apple-Mail-1--810451207--



From jnasby@pervasive.com Thu Feb  23 20:28:37 2006
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 05E209DCA8A
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Feb 2006 16:28:37 -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 65010-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Feb 2006 16:28:38 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from noel.decibel.org (noel.decibel.org [67.100.216.10])
	by postgresql.org (Postfix) with ESMTP id CE3FE9DC99F
	for <pgsql-performance@postgresql.org>;
	Thu, 23 Feb 2006 16:28:35 -0400 (AST)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id 77DA456455; Thu, 23 Feb 2006 14:29:06 -0600 (CST)
Received: (hashcash-sendmail, from uid 1001); Thu, 23 Feb 2006 14:29:05 -0600
Date: Thu, 23 Feb 2006 14:29:05 -0600
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Vivek Khera <vivek@khera.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: 
Message-ID: <20060223202905.GQ86022@pervasive.com>
References: 
 <544485BC51F81A41AC1A72CFA69013655640AF@AZ18EV805.global.ds.honeywell.com>
	<62FC5203-3162-4ABE-BF47-DFE0116AC520@khera.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <62FC5203-3162-4ABE-BF47-DFE0116AC520@khera.org>
X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.11
X-Hashcash: 1:20:060223:vivek@khera.org::lQLI7ysWsVVBT9Xw:000Mni
X-Hashcash: 
 1:20:060223:pgsql-performance@postgresql.org::yuOdj6M429SWipfv:00000
	00000000000000000000000068Ze
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.105 required=5 tests=[AWL=0.105]
X-Spam-Score: 0.105
X-Spam-Level: 
X-Archive-Number: 200602/375
X-Sequence-Number: 17361

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



From pgman@candle.pha.pa.us Sat Feb  25 03:42:35 2006
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 <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-performance@postgresql.org>;
	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 <pgman@candle.pha.pa.us>
Message-Id: <200602250342.k1P3gdj15861@candle.pha.pa.us>
Subject: Re: 
In-Reply-To: <20060223202905.GQ86022@pervasive.com>
To: "Jim C. Nasby" <jnasby@pervasive.com>
Date: Fri, 24 Feb 2006 22:42:39 -0500 (EST)
CC: Vivek Khera <vivek@khera.org>,
	Postgresql Performance <pgsql-performance@postgresql.org>
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. +