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_sizeor 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.