Home > mailing lists

shared_buffer - PostgreSQL 9.2 - Mailing list pgsql-admin

From	Lucas Possamai
Subject	shared_buffer - PostgreSQL 9.2
Date	May 13, 2016 07:14:12
Msg-id	CAE_gQfU+vq1aVERiziGXws-xz04yks5hRH0mbkpHON3NJnsT=Q@mail.gmail.com Whole thread Raw
Responses	Re: shared_buffer - PostgreSQL 9.2 (Keith <keith@keithf4.com>)
List	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

From: koff10
Date: 12 May 2016, 02:02:34
Subject: good tutorial pgloader 3X

From: Keith
Date: 13 May 2016, 07:30:33
Subject: Re: shared_buffer - PostgreSQL 9.2