Re: effective_cache_size and work_ram

Hi, yes it is a dedicated server. and THANKS!

On 12 Dec 2012, at 3:55 PM, Pavel Stehule wrote:

> 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