pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re:
3+ messages / 3 participants
[nested] [flat]

* Re:
@ 2006-02-23 14:38 Vivek Khera <vivek@khera.org>
  2006-02-23 20:29 ` Re: Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Vivek Khera @ 2006-02-23 14:38 UTC (permalink / raw)
  To: pgsql-performance


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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re:
  2006-02-23 14:38 Re: Vivek Khera <vivek@khera.org>
@ 2006-02-23 20:29 ` Jim C. Nasby <jnasby@pervasive.com>
  2006-02-25 03:42   ` Re: Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Jim C. Nasby @ 2006-02-23 20:29 UTC (permalink / raw)
  To: Vivek Khera <vivek@khera.org>; +Cc: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re:
  2006-02-23 14:38 Re: Vivek Khera <vivek@khera.org>
  2006-02-23 20:29 ` Re: Jim C. Nasby <jnasby@pervasive.com>
@ 2006-02-25 03:42   ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2006-02-25 03:42 UTC (permalink / raw)
  To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: Vivek Khera <vivek@khera.org>; pgsql-performance


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. +



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-02-25 03:42 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-23 14:38 Re: Vivek Khera <vivek@khera.org>
2006-02-23 20:29 ` Jim C. Nasby <jnasby@pervasive.com>
2006-02-25 03:42   ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox