Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Increase cache hit rate #3142

Open
mathjazz opened this issue Mar 12, 2024 · 1 comment
Open

Increase cache hit rate #3142

mathjazz opened this issue Mar 12, 2024 · 1 comment
Assignees
@mathjazz
Labels
P2 We want to ship it soon, possibly in the current quarter performance task

Comments

@mathjazz
Copy link
Collaborator

Our table cache hit rate currently stands at 0.85 and is consistently below the recommended value of 0.99. In such case it is recommended to upgrade database plan for more RAM.

As per the docs, the best way to understand what plan is best for your workload is to try them.

Our initial testing didn't show significant gains, but that could have been caused by cold cache.
@mathjazz mathjazz added P2 We want to ship it soon, possibly in the current quarter task performance labels Mar 12, 2024
@mathjazz mathjazz self-assigned this Mar 12, 2024
@mathjazz
Copy link
Collaborator Author

mathjazz commented May 27, 2024 •
edited

Upgraded plan on prod to Standard 2 today. Let's observe how that affects the cache hit rate and the overall performance.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mathjazz mathjazz

Labels
P2 We want to ship it soon, possibly in the current quarter performance task
Projects
Pontoon 2024 Q1
Status: Performance Optimization (Low Priority)
Milestone
No milestone
Development

No branches or pull requests
1 participant
@mathjazz