From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk> |
Cc: | "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: effective_cache_size and work_ram |
Date: | 2012-12-12 07:55:25 |
Message-ID: | CAFj8pRB6Jj1hZeEpnWAY0JNXoN39gc7jx964oc8K4DEcSvKUgA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello
2012/12/12 ac(at)hsk(dot)hk <ac(at)hsk(dot)hk>:
> Hi,
>
> I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to
> turn the server with the following changes from default:
>
> max_connections = 100 # default
> shared_buffers = 2048MB # change from 24MB to 2048MB as I think 24MB is not
> enough
> maintenance_work_mem = 400MB # 50MB/GB x 8GB
> effective_cache_size = 4096MB # Set to 50% of total RAM
> work_mem = 24MB
> checkpoint_segments = 10
> wal_buffers = 16MB
>
> Are these values reasonable?
it is dedicated server?
then effective_cache_size can be higher maybe 6GB
checkpoint_segments are too low, can be 128
Regards
Pavel Stehule
>
> Thanks
> ac
From | Date | Subject | |
---|---|---|---|
Next Message | ac@hsk.hk | 2012-12-12 08:06:43 | Re: effective_cache_size and work_ram |
Previous Message | ac@hsk.hk | 2012-12-12 07:26:50 | effective_cache_size and work_ram |