Postgres Pro
Downloads
Home   >   mailing lists

Re: How to tune my new server - Mailing list pgsql-general

From Joseph Kregloh
Subject Re: How to tune my new server
Date
Msg-id CAAW2xffyB_ULgg7pU0rO-EiZHDJ6a-gfBLDAkmcoda-AUwjTyA@mail.gmail.com
Whole thread Raw
In response to How to tune my new server  (Sachin Srivastava <ssr.teleatlas@gmail.com>)
Responses Re: How to tune my new server
List pgsql-general
Tree view
When tuning the last server that we built I followed the following Wiki page as to where to make adjustments https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server then tested the tweaks using pgbench tools from https://github.com/gregs1104/pgbench-tools. Of course not every machine is built the same and not every PostgreSQL server is used the same, to tune according to the machine and the usage of the server.

Thanks,
-Joseph Kregloh

On Tue, Aug 18, 2015 at 5:52 AM, Sachin Srivastava <ssr.teleatlas@gmail.com> wrote:
Hi,

If my system RAM is 50 GB then how can I tune my database server without using the Thumb rule of postgresql.conf parameter like:

Shared_buffer: 25% of the RAM
temp_buffers: should be default
work_mem: AvRAM/2 * Max_connections
etc...

There is any another way or any other rule or Tool which can recommend me to tune my database.

Regards,
Sachin

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to get cursor query
Next
From: Tom Lane
Date:
Subject: Re: How to get cursor query