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