Postgres Pro
Downloads
Home   >   mailing lists

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

From Sachin Srivastava
Subject How to tune my new server
Date
Msg-id CAFzqEhLCTy4o3D9sCGKFPB8XQxM4PLvwqp2qj5AWsMS=nwa7rw@mail.gmail.com
Whole thread Raw
Responses Re: How to tune my new server
List pgsql-general
Tree view
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: "Peter J. Holzer"
Date:
Subject: Upgrade from postgresql-9.5alpha1 to postgresql-9.5alpha2 (Debian packages)
Next
From: Mitu Verma
Date:
Subject: deletion of the thread posted by me