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 по дате отправления: