Suggest the best values for the postgres configuration parameters

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Suggest the best values for the postgres configuration parameters
Date: 2018-04-10 17:32:50
Message-ID: CAEHH7R4NhZ8EvEubw9vo6j4xZ0RSsYxBumo_FC73OECRb6cfGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-04-10 17:36:54 difference between checkpoint_segments and wal_keep_segments in postgres configuration file
Previous Message Adrian Klaver 2018-04-10 17:07:19 Re: Postgresql Split Brain: Which one is latest