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

[Bug] Experiment results query hangs for postgres 12+ #2253

Open
overborn opened this issue Mar 21, 2024 · 0 comments
Open

[Bug] Experiment results query hangs for postgres 12+ #2253

overborn opened this issue Mar 21, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@overborn
Copy link

overborn commented Mar 21, 2024

Summary

After upgrading our RDS from version 11 to 15, we have noticed that growthbook experiment queries, which previously took about minute to complete, currently hang for 24+ hours (with no success), keeping a 100% load of the database for Postgres 12+.
The reason is that postgres reapproched common table expressions.
In order for generated query to be able to run in reasonable time, we should be able to extend expressions like
WITH __rawExperiment as ( ... with WITH __rawExperiment as MATERIALIZED ( ...

Expected Behavior

Experiment result query should run in reasonable time (2 min or less)- same time for postres 11 and 12+

Current Behavior

Experiment result query hangs for days and loads 100% CPU for postgres 12+.

@overborn overborn added the bug Something isn't working label Mar 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant