shared_buffer - PostgreSQL 9.2

From: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: shared_buffer - PostgreSQL 9.2
Date: 2016-05-13 04:13:27
Message-ID: CAE_gQfU+vq1aVERiziGXws-xz04yks5hRH0mbkpHON3NJnsT=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi guys,

I currently have a master Postgres server with 128GB RAM.

the shared_buffer is now = 51GB

I read that I should decreased it to something about 32GB

But, I don't wanna have IO issues, that's why the shared_buffer is too high.

Am I going to have IO issues if decrease it?

Cheers
Lucas

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2016-05-13 04:29:45 Re: shared_buffer - PostgreSQL 9.2
Previous Message koff10 2016-05-11 23:02:26 good tutorial pgloader 3X