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.

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

Warm up query plan cache at boot using persisted queries #5334

Closed
lleadbet opened this issue Jun 4, 2024 · 0 comments · Fixed by #5340
Closed

Warm up query plan cache at boot using persisted queries #5334

lleadbet opened this issue Jun 4, 2024 · 0 comments · Fixed by #5340

Comments

@lleadbet
Copy link
Contributor

lleadbet commented Jun 4, 2024

Describe the solution you'd like

With the current warmup implementation, the router will only warm up the query plan cache when it has been reloaded through a schema update (e.g. Uplink) or config update (when using --hr or --dev).

Persisted queries affords the opportunity to use known queries to prepopulate the cache prior to serving any traffic on initial boot, and should be used as such in addition to the updating logic.

Describe alternatives you've considered

Running the router in prod with --hr and sending a SIGHUP command to force a refresh.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant