Re: Low cache hit ratio

2021-07-29 Thread Philip Semanchuk
> On Jul 29, 2021, at 3:09 AM, Lucas wrote: > > Hello, > > I have recently deployed a new Slave (streaming replication) and have been > monitoring its cache hit ratio. > > At the moment, read-only queries are being sent to this slave but only 10% of > the traffic. > The cache hit ratio is

Low cache hit ratio

2021-07-29 Thread Lucas
Hello, I have recently deployed a new Slave (streaming replication) and have been monitoring its cache hit ratio. At the moment, read-only queries are being sent to this slave but only 10% of the traffic. The cache hit ratio is now at 82%. This database is around 1.4TB and is running on EC2 in