Re: Increased I/O / Writes

Поиск
Список
Период
Сортировка
От Johnny Morano
Тема Re: Increased I/O / Writes
Дата
Msg-id D710C88BF90D514FACFEC1AEA215BD669CC34FDB@BO-VM-EXCHANGE1.office.payon.com
обсуждение исходный текст
Ответ на Re: Increased I/O / Writes  (Lucas Possamai <drum.lucas@gmail.com>)
Список pgsql-general
Дерево обсуждения

Hi

 

Why not use https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/ to determine your optimal shared_buffers  settings? ;-)

 

Cheers

Johnny

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Lucas Possamai
Sent: Dienstag, 17. Mai 2016 06:12
To: Sergey Konoplev
Cc: Postgres General
Subject: Re: [GENERAL] Increased I/O / Writes

 

This is my postgresql.conf at the moment:

 

shared_buffer(51605MB) + 

effective_cache_size(96760MB) + 

work_mem(32MB) + 

max_connections(200) 

 

= 148397.08 MB

 

My server has 128GB of RAM

 

So, I'm using more RAM that I have. (not good at all)

I'm glad that it wasn't me who put those confs in there :)

 

 

Anyway...

I was thinking about decrease the shared_buffer to something like 1/8 of total RAM = 16GB

 

What do u guys think about it?

 

Cheers

Lucas

 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Martijn Tonies \(Upscene Productions\)"
Дата:
Сообщение: Re: How to convert firebird stored procedures into postgresql functions
Следующее
От: Pierre Chevalier Géologue
Дата:
Сообщение: Re: Thoughts on "Love Your Database"