Postgres Pro
Downloads
Home   >   mailing lists

Re: Increased I/O / Writes - Mailing list pgsql-general

From Lucas Possamai
Subject Re: Increased I/O / Writes
Date
Msg-id CAE_gQfXJWyfR9aCED_E9q9JB6WJPurg8Sv_hcoLv6HLzCkerzw@mail.gmail.com
Whole thread Raw
In response to Re: Increased I/O / Writes  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Increased I/O / Writes
Re: Increased I/O / Writes
List pgsql-general
Tree view
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 by date:

Previous
From: Guyren Howe
Date:
Subject: Re: FIRST_VALUE argument must appear in group by?
Next
From: Charles Clavadetscher
Date:
Subject: Re: Ascii Elephant for text based protocols - Final