Postgres Pro
Downloads
Home   >   mailing lists

Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9 - Mailing list pgsql-general

From tuanhoanganh
Subject Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9
Date
Msg-id AANLkTikoyzg8kkzXovCUfFowvM+t0E_eP5Z0Krt08m4K@mail.gmail.com
Whole thread Raw
In response to good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9  (AI Rumman <rummandba@gmail.com>)
Responses Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view
I have same question

My Computer is running POS with Postgres 8.9.11 database
 Ram : 16GB
 OS : Windows 2008 R2
 CPU XEON 2G
 User : 50-60 user (connect ~ 200 connects, I increase Windows SharedSection=1024,20480,1024 for > 125 connects).
 DISK : RAID 1

What will be good settings for DB parameters such as shared_buffers, checkpoint_segment and etc.
My application run slowly when >= 30 users

Thank for your help.
Tuan Hoang Anh

On Thu, Nov 11, 2010 at 2:59 PM, AI Rumman <rummandba@gmail.com> wrote:
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.

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Problem with to_tsquery() after restore on PostgreSQL 9.0.1
Next
From: "Marc Mamin"
Date:
Subject: Re: REINDEX requirement?