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

index on jsonb keys possible? #178

Open

derkod opened this issue Sep 30, 2020 · 1 comment

derkod commented Sep 30, 2020

Our Observation-table contain some 67000000 records. Mostly they will be retrieved by using a filter on phenomenonTime. It takes up to 30 seconds to get the desired records. Is this normal?
Is it possible to create an index on phenomenonTime like is done at https://stackoverflow.com/questions/18404055/index-for-finding-an-element-in-a-json-array/18405706#18405706 and do you think this will work with the GOST-server?

Contributor

bertt commented Oct 1, 2020

Hi, 30 seconds is quite slow. You can analyze the generated queries see https://github.com/gost/docs/blob/master/gost_debug_sql_queries.md

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