Search Postgresql Archives

Re: effective_cache_size X shared_buffer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 

On Mon, Apr 3, 2017 at 1:33 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:
2017-04-03 13:23 GMT+12:00 Patrick B <patrickbakerbr@xxxxxxxxx>:
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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux