Обсуждение: How to tune my new server
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:work_mem: AvRAM/2 * Max_connections
etc...
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:
SachinRegards,temp_buffers: should be defaultShared_buffer: 25% of the RAMHi,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:work_mem: AvRAM/2 * Max_connectionsetc...There is any another way or any other rule or Tool which can recommend me to tune my database.
On 8/18/2015 6:33 AM, Joseph Kregloh wrote: > 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. > indeed, your use case heavily affects the optimal decisions, there's no one-size-fits-all answer. are you doing OLTP, characterized by frequent small transactions with high percentage of update events and many clients, or is this OLAP, where you bulk load large data, then do relatively few very large aggregate type queries for reporting purposes ? -- john r pierce, recycling bits in santa cruz