Re: Increased I/O / Writes

From: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Increased I/O / Writes
Date: 2016-05-17 04:11:31
Message-ID: CAE_gQfXJWyfR9aCED_E9q9JB6WJPurg8Sv_hcoLv6HLzCkerzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Viswanath 2016-05-17 04:43:24 Re: Update or Delete causes canceling of long running slave queries
Previous Message Guyren Howe 2016-05-17 04:04:46 Re: FIRST_VALUE argument must appear in group by?