Re: Increased I/O / Writes

From: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
To: Kevin Grittner <kgrittn(at)gmail(dot)com>
Cc: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Increased I/O / Writes
Date: 2016-05-17 22:56:18
Message-ID: CAE_gQfX81xCkxs0vh2yyYBNvviV5renb4j+rmn_N2rEGLGUbnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-05-17 23:11:11 Re: Increased I/O / Writes
Previous Message Steve Kehlet 2016-05-17 20:04:34 Re: preventing ERROR: multixact "members" limit exceeded