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

[tuanhoanganh <hatuan05@xxxxxxxxx>]

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@xxxxxxxxx> 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.