Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Thu, Nov 11, 2010 at 3:30 AM, tuanhoanganh <hatuan05@xxxxxxxxx> wrote:
>> My Computer is running POS with Postgres 8.9.11 database

Not sure which version is that. There's nothing like 8.9.11 ...

>> Â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.

Well, it's always useful to have a decent settings (default one is very
conservative and may significantly hurt performance in some cases).
Anyway, on Linux I'd bump up shared buffers (to something like 512MB) and
work_mem (maybe 4MB), increased effective_cache_size (to about 10GB), etc.
But he mentions Windows 2008 and I have no experience with running PG on
this OS.

> What kind of disk do you have? Are these just local SATA drives?
> Perhaps you need faster drives.

I think it's too early to recommend buying faster drives. You have not
identified the bottleneck and what's causing it.

regards
Tomas


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux