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

order by clause uses excessive memory #8799

Open
coffeegoddd opened this issue Jan 29, 2025 · 0 comments
Open

order by clause uses excessive memory #8799

coffeegoddd opened this issue Jan 29, 2025 · 0 comments
Labels
bug Something isn't working performance

Comments

@coffeegoddd
Copy link
Contributor

Dolt version v1.48.0.

Running select * from option_chain order by act_symbol desc uses > 30GB of ram before being killed by terminal.

% dolt clone post-no-preference/options
% cd options
options % dolt sql -q "select * from option_chain order by act_symbol desc;"
zsh: killed     dolt sql -q "select * from option_chain order by act_symbol desc;"
options % dolt sql -q "select count(*) from option_chain;"
+----------+
| count(*) |
+----------+
| 75275980 |
+----------+
@timsehn timsehn added bug Something isn't working performance labels Feb 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working performance
Projects
None yet
Development

No branches or pull requests

2 participants