On Mon, Apr 3, 2017 at 1:33 PM, Patrick B <patrickbake...@gmail.com> wrote:
> 2017-04-03 13:23 GMT+12:00 Patrick B <patrickbake...@gmail.com>: > >> Hi guys. >> >> I'm thinking about increasing the query cache for my PG 9.2 server. >> I've got a project happening, which is doing lots and lots of writes and >> reads during the night, and in the morning I see PG cache warming up again, >> as all the cache "was used" by those write and read tasks. >> >> So my environment gets very slow for a few hours, until the queries used >> on a daily basis go to the cache. >> >> Question: >> Should I increase effective_cache_size or shared_buffer? What's the >> difference between them? >> >> Thanks >> Patrick >> > > Can I also increase shared_buffer on my slave only? Would that make any > difference if using selects on the slave? Or this parameter must be the > same across all servers (Master/slaves) ? > Yes, you can increase the shared_buffers in the slave database. Configuration can be different across master and slave databases. Regards, Venkata B N Database Consultant
