Postgres Pro
Downloads
Home   >   mailing lists

Suggest the best values for the postgres configuration parameters - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject Suggest the best values for the postgres configuration parameters
Date
Msg-id CAEHH7R4NhZ8EvEubw9vo6j4xZ0RSsYxBumo_FC73OECRb6cfGA@mail.gmail.com
Whole thread Raw
Responses Re: Suggest the best values for the postgres configurationparameters
List pgsql-general
Tree view
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
​​


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgresql Split Brain: Which one is latest
Next
From: Raghavendra Rao J S V
Date:
Subject: difference between checkpoint_segments and wal_keep_segments inpostgres configuration file