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

Feedback: SET {session variable} : no documentation for unbounded_parallel_scans #19000

Open
hand-crdb opened this issue Oct 9, 2024 · 0 comments

Comments

@hand-crdb
Copy link

hand-crdb commented Oct 9, 2024

Page: https://cockroachlabs.com/docs/v24.2/set-vars.html

What is the reason for your feedback?

[X] Missing the information I need

[ ] Too complicated

[ ] Out of date

[ ] Something is broken

[ ] Other

Additional details

This page does not contain documentation on the unbounded_parallel_scans session variable.

This variable is mentioned in What's New in v23.1
https://www.cockroachlabs.com/docs/releases/v23.1#v23-1-2-sql-language-changes

SQL language changes

Added a new session variable unbounded_parallel_scans, which controls whether scans will be parallelized across ranges in more cases. Note that using this feature can lead to increased likelihood of out-of-memory errors (OOMs), so it should be used with care (namely when you expect that the scan should read a "reasonable" number of rows - probably less than 10k). Also note that queries with LIMITs aren't affected by this variable; cross-range parallelism of scans continue to be disabled for such queries. #100948

Jira issue: DOC-11408

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant