Search Postgresql Archives

Suggest the best values for the postgres configuration parameters

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

 



We are using postgres 9.2  version on Centos operating system. 

Total ram available is 80GB . At present we don't have any connection pool mechanisiam.  Max number of  connections are allowed is 1000. 

Could you please suggest the best values for the below configuration parameters?

  • shared_buffers 
  • effective_cache_size 
  • work_mem 
  • maintenance_work_mem 
  • checkpoint_segments 
  • wal_keep_segments 
  • checkpoint_completion_target 
  • Max_prepared_transactions =0  
--
Regards,
Raghavendra Rao J S V
​​



[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