`order by` clause uses excessive memory
Open
bug
performance
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
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 |
+----------+
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.