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) ? Thanks P.
