Re: How to tune my new server

Поиск
Список
Период
Сортировка
От Joseph Kregloh
Тема Re: How to tune my new server
Дата
Msg-id CAAW2xffyB_ULgg7pU0rO-EiZHDJ6a-gfBLDAkmcoda-AUwjTyA@mail.gmail.com
обсуждение исходный текст
Ответ на How to tune my new server  (Sachin Srivastava <ssr.teleatlas@gmail.com>)
Ответы Re: How to tune my new server
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to get cursor query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to get cursor query