pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Crawford <scrawford@pinpointresearch.com>
To: Aftab Alam <aalam@tsrdarashaw.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres Performance
Date: Thu, 20 Mar 2008 15:13:49 -0700
Message-ID: <47E2E19D.1050909@pinpointresearch.com> (raw)
In-Reply-To: <fc8d635e-6c27-4d85-9d14-eb5bc181e1b1>
References: <fc8d635e-6c27-4d85-9d14-eb5bc181e1b1>

Aftab Alam wrote:
>
> Dear All,
>
>  
>
>             I am using postgres 7.0 with linux with 15 GB of database 
> & 3 gb of RAM.
>
> Can anyone suggest what is the best setting for postgres. I am using 
> postgres as web db.
>
>
I'm going to assume/hope that you mean 8.0. Even then, you would be well 
advised to upgrade. 8.0 is over three years old and no amount of tuning 
will make it as fast as the newer releases.

Then look at http://www.google.com/search?q=postgresql+tuning

The Varlena articles are good even if dated. After reading a few pages 
and trying a bit of experimentation, check back with unanswered 
questions. Nobody can recommend a "best setting" without a thorough 
understanding of your workload. Or even if they do - 
guidelines/suggestions is the best you will find.

Cheers,
Steve



view thread (12+ messages)  latest in thread

Message-ID: <47E2E19D.1050909@pinpointresearch.com>
Permalink:  ../47E2E19D.1050909@pinpointresearch.com/
Also on:    postgresql.org/message-id/47E2E19D.1050909@pinpointresearch.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scrawford@pinpointresearch.com, aalam@tsrdarashaw.com
  Subject: Re: Postgres Performance
  In-Reply-To: <47E2E19D.1050909@pinpointresearch.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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