Re: [GENERAL] effective_cache_size X shared_buffer

2017-04-02 Thread Venkata B Nagothi
On Mon, Apr 3, 2017 at 1:33 PM, Patrick B wrote: > 2017-04-03 13:23 GMT+12:00 Patrick B : > >> 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 morni

Re: [GENERAL] effective_cache_size X shared_buffer

2017-04-02 Thread Venkata B Nagothi
On Mon, Apr 3, 2017 at 11:23 AM, Patrick B wrote: > 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 th

Re: [GENERAL] effective_cache_size X shared_buffer

2017-04-02 Thread Patrick B
2017-04-03 13:23 GMT+12:00 Patrick B : > 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

[GENERAL] effective_cache_size X shared_buffer

2017-04-02 Thread Patrick B
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 enviro