Re: Cache Hit Ratio%

Поиск
Список
Период
Сортировка
От Fabio Pardi
Тема Re: Cache Hit Ratio%
Дата
Msg-id 315bff99-bad6-6224-edd3-a1103fe2c73c@portavita.eu
обсуждение исходный текст
Ответ на Cache Hit Ratio%  (<soumik.bhattacharjee@kpn.com>)
Ответы RE: Cache Hit Ratio%  (<soumik.bhattacharjee@kpn.com>)
Список pgsql-admin
Дерево обсуждения
Hi,

I would start checking (and comparing with pre-prod) the db size, the shared_buffers size, how much data end up in cache and how are the cache layer's used.

regards,

fabio pardi


On 28/07/2020 10:04, soumik.bhattacharjee@kpn.com wrote:

Dear Experts,

 

We have done production migration from Oracle to PostgreSQL.

 

Could you please help me to know where to look out for - the Cache Hit Ratio is always at 65.72% , but in lower Pre-Prod env it’s kind of 95%.

 

As such no major slowness is reported by the customer so far.

 

 

Thanks

 

 

 

 

 


В списке pgsql-admin по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Cache Hit Ratio%
Следующее
От:
Дата:
Сообщение: RE: Cache Hit Ratio%