Search Postgresql Archives

Re: effective_cache_size and work_ram

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

 



hello

2012/12/12 ac@xxxxxx <ac@xxxxxx>:
> 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


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