On Thu, Nov 11, 2010 at 3:30 AM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
> 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
I'd start by optimizing your queries, and looking for both extra and
missing indexes that would help your queries.
What kind of disk do you have? Are these just local SATA drives?
Perhaps you need faster drives.