Postgres Pro
Downloads
Home   >   mailing lists

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

From Johnny Morano
Subject Re: Increased I/O / Writes
Date
Msg-id D710C88BF90D514FACFEC1AEA215BD669CC34FDB@BO-VM-EXCHANGE1.office.payon.com
Whole thread Raw
In response to Re: Increased I/O / Writes  (Lucas Possamai <drum.lucas@gmail.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: "Martijn Tonies \(Upscene Productions\)"
Date:
Subject: Re: How to convert firebird stored procedures into postgresql functions
Next
From: Pierre Chevalier Géologue
Date:
Subject: Re: Thoughts on "Love Your Database"