index on jsonb keys possible?

Open derkod opened this issue 5 years ago • 1 comments

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?

Sep 30 '20 11:09 derkod

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

Oct 01 '20 07:10 bertt