How to tune my new server

From: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to tune my new server
Date: 2015-08-18 09:52:14
Message-ID: CAFzqEhLCTy4o3D9sCGKFPB8XQxM4PLvwqp2qj5AWsMS=nwa7rw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitu Verma 2015-08-18 10:08:29 deletion of the thread posted by me
Previous Message Peter J. Holzer 2015-08-18 09:06:15 Upgrade from postgresql-9.5alpha1 to postgresql-9.5alpha2 (Debian packages)