From: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
---|---|
To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: effective_cache_size X shared_buffer |
Date: | 2017-04-03 04:58:15 |
Message-ID: | CAEyp7J8LwYy3uruW20=mzSwZ10qe9w+ECBvsqQX1reEi+h1z7g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Apr 3, 2017 at 1:33 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:
> 2017-04-03 13:23 GMT+12:00 Patrick B <patrickbakerbr(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2017-04-03 07:31:15 | Suggestion to improve select pg_reload_conf() |
Previous Message | Venkata B Nagothi | 2017-04-03 04:57:01 | Re: effective_cache_size X shared_buffer |