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(at)gmail(dot)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.
>