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

Suboptimal query plan for nearest-neighbor join in combination with caching #1554

Open
hannahbast opened this issue Oct 15, 2024 · 0 comments
Open

Suboptimal query plan for nearest-neighbor join in combination with caching #1554

hannahbast opened this issue Oct 15, 2024 · 0 comments
Assignees
@joka921 @ullingerc

Comments

@hannahbast
Copy link
Member

hannahbast commented Oct 15, 2024 •
edited
Loading

The following query works fine with an empty cache. But when executing the query for country X and then for country Y, without clearing the cache inbetween, the query plan computes the huge join ?stop geo:hasGeometry/geo:asWKT ?stop_location first, which of course runs out of memory.

https://qlever.cs.uni-freiburg.de/osm-planet/XDlWCF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@joka921 joka921

@ullingerc ullingerc

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@hannahbast @joka921 @ullingerc