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

geogfn: investigate making point intersects cheaper #70097

Open
otan opened this issue Sep 12, 2021 · 2 comments
Open

geogfn: investigate making point intersects cheaper #70097

otan opened this issue Sep 12, 2021 · 2 comments
Labels
A-spatial Spatial work that is *not* related to builtins. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team

Comments

@otan
Copy link
Contributor

otan commented Sep 12, 2021

See #69762.

Points intersection could be cheaper in CRDB by comparing whether two points are equal. Currently, we use intersectscell, which allows for 1cm of error (do we want that?) but does make it slower. Changing this is a potentially backwards incompatible change, so deferring this as an issue.

Jira issue: CRDB-9938

@blathers-crl
Copy link

blathers-crl bot commented Sep 12, 2021

Hi @otan, please add a C-ategory label to your issue. Check out the label system docs.

While you're here, please consider adding an A- label to help keep our repository tidy.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

@otan otan added A-spatial Spatial work that is *not* related to builtins. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) labels Sep 13, 2021
@otan otan changed the title geogfn: make point intersects cheaper geogfn: investigate making point intersects cheaper Sep 13, 2021
@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@rafiss rafiss added T-spatial Spatial Team T-sql-queries SQL Queries Team and removed no-issue-activity T-spatial Spatial Team labels Aug 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-spatial Spatial work that is *not* related to builtins. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
Status: Backlog
Development

No branches or pull requests

2 participants