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.

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

[yugabyted] How to create a spatial index on a PostgreSQL GEOMETRY field? #17316

Closed
1 task done
julor opened this issue May 12, 2023 · 3 comments
Closed
1 task done

[yugabyted] How to create a spatial index on a PostgreSQL GEOMETRY field? #17316

julor opened this issue May 12, 2023 · 3 comments
Labels
area/ecosystem Label for all ecosystem related projects kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@julor
Copy link

julor commented May 12, 2023 •
edited by jira bot
Loading

Jira Link: DB-6536

Description

I installed postgis extension.
Using a spatial index on geometry field will greatly increase the performance of spatial query，and many GIS softwares require spatial indexing to work.How do I create a spatial index？

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.
@julor julor added area/ecosystem Label for all ecosystem related projects area/ybd yugabyted project related Github tickets. status/awaiting-triage Issue awaiting triage labels May 12, 2023
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels May 12, 2023
@ddorian
Copy link
Contributor

ddorian commented May 12, 2023

Hi @julor

Looking at the docs http://postgis.net/workshops/postgis-intro/indexing.html, spatial indexes use GIST indexes, which we don't support yet: #1337

@julor
Copy link
Author

julor commented May 12, 2023

Will there be any development plans recently？

@ddorian
Copy link
Contributor

ddorian commented May 12, 2023

It's on the roadmap, see https://github.com/yugabyte/yugabyte-db#current-roadmap

@julor julor closed this as completed May 13, 2023
@yugabyte-ci yugabyte-ci removed status/awaiting-triage Issue awaiting triage area/ybd yugabyted project related Github tickets. labels May 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/ecosystem Label for all ecosystem related projects kind/bug This issue is a bug priority/medium Medium priority issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ddorian @julor @yugabyte-ci