-
-
Notifications
You must be signed in to change notification settings - Fork 11
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
Support for json/jsonb data types #9
Comments
Nevermind, looks like it's intended behavior:
the If I remove the restriction it attempts to create an index but not a correct one for the query:
Which, I assume, is why there was a limited list of supported |
That's right, we currently only support single column btree indexs, which are not appropraite for json/b data types. The underlying HypoPG extension has support for
so, unfortunately, there is currently no appropriate target for JSON/B columns I'll leave this open in case other come across this limitation too |
Hi!
First of all, thanks a lot for this extension, it's a really cool :)
Describe the bug
index_advisor function does not suggest indexes for queries where the
WHERE
close uses the->>
operator.To Reproduce
Steps to reproduce the behavior:
Expected behavior
I expected the
index_statements
to have suggestion of an index.This index seems like it could have been suggested:
Versions:
Notes
This does not seem to be a hypopg limitations,
The text was updated successfully, but these errors were encountered: