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

Default search_index is created as btree #61

Open
Nepherhotep opened this issue Aug 9, 2015 · 3 comments
Open

Default search_index is created as btree #61

Nepherhotep opened this issue Aug 9, 2015 · 3 comments

Comments

@Nepherhotep
Copy link

Default search_index created using btree:

CREATE INDEX tablename_a71a185f
ON "tablename"
USING btree
(search_index);

Shouldn't it use gin or gist instead? Is it possible to configure vector field to use them, or only further migration altering it will work?

P.S. Maybe issue tracker is not the perfect place for such discussions, but it might be useful for community if I create pull request extending readme with answer.

@vladiibine
Copy link

Agreed. GIN or GIST would be exactly the index types I'd use, so this would be a nice feature to have.

@hyusetiawan
Copy link

any update on this?

@Nepherhotep
Copy link
Author

No, currently Django doesn't have native support of functional indexes, so the only way to do it - not to use this library and write a custom migration.
However, since Django 1.9 it will support indexes other than BTREE (if we are lucky :), so maybe this library can be easily extended as well.

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

No branches or pull requests

3 participants