zzj1234-cmd opened a new issue, #49318: URL: https://github.com/apache/doris/issues/49318
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version apache-doris-2.1.8.1-bin-x64 ### What's Wrong? SELECT * from account_voucher_list order by id limit 23000000,10; The following exception was reported when performing deep paging query: FullGC release wg overcommit mem, wg id:1, name:normal, used:5.12 GB,limit:4.18 GB,backend:127.0.0.1. cancel top memory used tracker consumption 5.12 GB. details:process memory used 6.44 GB exceed soft limit 12.53 GB or sys available memory 546.90 MB less than warning water mark 1.55 GB. When I changed it to the following according to the official website's suggestions, I still got an error SELECT * from account_voucher_list where account_voucher_list.id > (select id from account_voucher_list order by id limit 1 offset 22999999) order by id limit 10; ### What You Expected? Doris can support deep paging without memory overflow. ### How to Reproduce? Check the last few pages in the table of 23 million data. ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
