good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9
Date: 2010-11-11 07:59:37
Message-ID: AANLkTi=qCyojFzQY1mfXrEuCQgphTZSy1OKrJRH-uArZ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am going to install Postgresql 9.0 for my running applicaiton which is at
8.1.
My Db size is 3 GB.
Server Specification:
dual-core 4 cpu
RAM: 32 GB
OS: Centos
What will be good settings for DB parameters such as shared_buffers,
checkpoint_segment and etc.
Any help please.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2010-11-11 08:19:58 Re: Problem with to_tsquery() after restore on PostgreSQL 9.0.1
Previous Message Allan Kamau 2010-11-11 06:42:19 Considering Solid State Drives