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

excessive memory usage during SELECT DISTINCT query #8488

Open
coffeegoddd opened this issue Oct 24, 2024 · 1 comment
Open

excessive memory usage during SELECT DISTINCT query #8488

coffeegoddd opened this issue Oct 24, 2024 · 1 comment
Labels
bug Something isn't working good repro Easily reproducible bugs performance sql server Issues related to the built in SQL server

Comments

@coffeegoddd
Copy link
Contributor

Dolt v1.43.7

dolt clone post-no-preference/options
cd options
dolt sql -q 'SELECT DISTINCT `act_symbol` FROM `option_chain` ORDER BY `act_symbol`;'

Executing this query uses almost 80GBs of memory locally and takes a long time to complete (if it completes at all)

@timsehn timsehn added bug Something isn't working performance sql server Issues related to the built in SQL server good repro Easily reproducible bugs labels Oct 24, 2024
@zachmu
Copy link
Member

zachmu commented Oct 24, 2024

@jycor I think this is probably due to some loop in GMS (or possibly dolt) not checking for context cancelation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good repro Easily reproducible bugs performance sql server Issues related to the built in SQL server
Projects
None yet
Development

No branches or pull requests

3 participants