8000 Tracking: optimizer session variables and hints · Issue #7491 · risingwavelabs/risingwave · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Tracking: optimizer session variables and hints #7491

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.

Sign up for GitHub

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

Jump to bottom
Open
1 of 5 tasks
kwannoel opened this issue Jan 19, 2023 · 2 comments
Open
1 of 5 tasks

Tracking: optimizer session variables and hints #7491

kwannoel opened this issue Jan 19, 2023 · 2 comments
Assignees
@kwannoel
Labels
type/feature Type: New feature. user-facing-changes Contains changes that are visible to users

Comments

@kwannoel
Copy link
Contributor
kwannoel commented Jan 19, 2023 •
edited
Loading

Session variables:

Semantics:

  • FORCE=false, ENABLE=true -> enable the optimization
  • FORCE=true, ENABLE=false -> whichever is set latest, will override the other option.
  • FORCE=true, ENABLE =true -> force using the optimization, whenever there's a choice between using it in some other optimization.
  • FORCE=false, ENABLE=false -> disable the optimization

https://www.postgresql.org/docs/current/runtime-config-query.html

Optimizer hints:

See discussion: #7014
@kwannoel kwannoel added the type/feature Type: New feature. label Jan 19, 2023
@kwannoel kwannoel self-assigned this Jan 19, 2023
@github-actions github-actions bot added this to the release-0.1.16 milestone Jan 19, 2023
This was referenced Jan 30, 2023
Closed
Closed
@chenzl25
Copy link
Contributor

DISABLE_TWO_PHASE_AGG and FORCE_TWO_PHASE_AGG seem can't be both set to true. A priority needs to be introduced.

@kwannoel kwannoel mentioned this issue Feb 7, 2023
Merged
5 tasks
@lmatz lmatz mentioned this issue Feb 9, 2023
Closed
@kwannoel kwannoel added the user-facing-changes Contains changes that are visible to users label Feb 9, 2023
@kwannoel kwannoel mentioned this issue Feb 10, 2023
Merged
7 tasks
@lmatz
Copy link
Contributor
lmatz commented Feb 15, 2023 •
edited
Loading

Suppose a query can utilize multiple indexes(but only exclusively) to accelerate itself, is it possible for the current optimizer to choose a suboptimal one?

I guess this can be supported only after hints are introduced if let's say this is necessary

@jon-chuang jon-chuang mentioned this issue Feb 28, 2023
Closed
2 tasks
@kwannoel kwannoel modified the milestones: release-0.18, release-0.19 Mar 17, 2023
@kwannoel kwannoel modified the milestones: release-0.19, release-0.20 Apr 24, 2023
@kwannoel kwannoel removed this from the release-1.0 milestone Jul 14, 2023
@chenzl25 chenzl25 mentioned this issue Apr 11, 2025
Open
8 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kwannoel kwannoel

Labels
type/feature Type: New feature. user-facing-changes Contains changes that are visible to users
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lmatz @chenzl25 @kwannoel
0