Re: Increased I/O / Writes

Поиск
Список
Период
Сортировка
От Lucas Possamai
Тема Re: Increased I/O / Writes
Дата
Msg-id CAE_gQfXJWyfR9aCED_E9q9JB6WJPurg8Sv_hcoLv6HLzCkerzw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Increased I/O / Writes  (Sergey Konoplev <gray.ru@gmail.com>)
Ответы Re: Increased I/O / Writes  (Johnny Morano <johnny.morano@payon.com>)
Re: Increased I/O / Writes  (Kevin Grittner <kgrittn@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Guyren Howe
Дата:
Сообщение: Re: FIRST_VALUE argument must appear in group by?
Следующее
От: Charles Clavadetscher
Дата:
Сообщение: Re: Ascii Elephant for text based protocols - Final