Re: Need help in setting optimal configuration for a huge database.

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Kishore B <kishorebh(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help in setting optimal configuration for a huge database.
Date: 2005-10-22 21:42:59
Message-ID: 20051022214259.GA22328@samfundet.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-10-22 21:57:49 Re: Need help in setting optimal configuration for a huge database.
Previous Message Kishore B 2005-10-22 21:15:25 Need help in setting optimal configuration for a huge database.

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-10-22 21:57:49 Re: Need help in setting optimal configuration for a huge database.
Previous Message Kishore B 2005-10-22 21:15:25 Need help in setting optimal configuration for a huge database.