PostgreSQL 9.3.2 Performance tuning for 32 GB server

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

 



Hi All,

I have configured the blow parameters for a 32 GB server . I this correct ?

shared_buffers = 6GB
work_mem = 24MB maintenance_work_mem = 250MB
effective_cache_size = 16GB
shared_preload_libraries = 'pg_stat_statements' pg_stat_statements.max = 10000 pg_stat_statements.track = all
wal_buffers = 8MB
checkpoint_segments = 32
checkpoint_completion_target = 0.9


--
--Regards
RAMAKRISHNAN KANDASAMY

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux