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-ow...@postgresql.org [mailto:pgsql-general-ow...@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
