From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: Kishore B <kishorebh@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help in setting optimal configuration for a huge database.
Date: Sat, 22 Oct 2005 23:42:59 +0200
Message-ID: <20051022214259.GA22328@samfundet.no> (raw)
In-Reply-To: <42567e060510221415r2516523l4c3f9b42dee91a09@mail.gmail.com>
References: <42567e060510221415r2516523l4c3f9b42dee91a09@mail.gmail.com>
On Sun, Oct 23, 2005 at 02:45:25AM +0530, Kishore B wrote:
> Database *:* Postgresql 7.3
You definitely want to upgrade this if you can.
> Memory : 2 GB
For 2GB of RAM, your effective_cache_size (100000) is a bit low (try doubling
it), and sort_mem (2048) is probably a bit too low as well.
/* Steinar */
--
Homepage: http://www.sesse.net/
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-performance@postgresql.org
Cc: sgunderson@bigfoot.com, kishorebh@gmail.com
Subject: Re: Need help in setting optimal configuration for a huge database.
In-Reply-To: <20051022214259.GA22328@samfundet.no>
* 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