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_gQfX81xCkxs0vh2yyYBNvviV5renb4j+rmn_N2rEGLGUbnw@mail.gmail.com
Whole thread Raw
In response to Re: Increased I/O / Writes  (Kevin Grittner <kgrittn@gmail.com>)
Responses Re: Increased I/O / Writes
Re: Increased I/O / Writes
List pgsql-general
Tree view
Following https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/ 
and http://pgtune.leopard.in.ua/ and https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server 
I changed the shared_buffer from 51GB to 35GB.

Now, I'm getting spikes every 15 minutes.

FATAL:  sorry, too many clients already


The change have been made 3 hours ago. 

- we rebooted the server as well

Might be the cache warming up again?


pgsql-general by date:

Previous
From: Steve Kehlet
Date:
Subject: Re: preventing ERROR: multixact "members" limit exceeded
Next
From: John R Pierce
Date:
Subject: Re: Increased I/O / Writes