Search Postgresql Archives
How to tune my new server
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: How to tune my new server
From
: Sachin Srivastava <
ssr.teleatlas@xxxxxxxxx
>
Date
: Tue, 18 Aug 2015 15:22:14 +0530
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: How to tune my new server
From:
Joseph Kregloh
Prev by Date:
Upgrade from postgresql-9.5alpha1 to postgresql-9.5alpha2 (Debian packages)
Next by Date:
deletion of the thread posted by me
Previous by thread:
Upgrade from postgresql-9.5alpha1 to postgresql-9.5alpha2 (Debian packages)
Next by thread:
Re: How to tune my new server
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
