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.

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

Document 20190114 alpha release of optimizer query plan cache #4238

Closed
rmloveland opened this issue Jan 14, 2019 · 1 comment
Closed

Document 20190114 alpha release of optimizer query plan cache #4238

rmloveland opened this issue Jan 14, 2019 · 1 comment
Assignees
@rmloveland
Labels
P-0 Urgent; must be done in next 2 weeks T-enhancement

Comments

@rmloveland
Copy link
Contributor

Document the alpha release of the query plan cache. It's behind a flag, off by default.

For more information, see the following:
@rmloveland rmloveland added T-enhancement A-sql P-0 Urgent; must be done in next 2 weeks labels Jan 14, 2019
@rmloveland rmloveland self-assigned this Jan 14, 2019
rmloveland added a commit that referenced this issue Jan 14, 2019
@rmloveland
Update optimizer docs for 20190114 alpha
3e3d38b 
Fixes #3996, #3998, #4238.

Summary of changes:

- Add section about table statistics, including:

   - How to generate statistics manually

   - How to use the new automatic statistics feature

- Add section describing the new query plan cache and how to use it.

- Add section listing the types of statements supported by the
  optimizer.  This is not exhaustive, but is meant to be a quick list of
  the types of statements supported by the optimizer.  It points the
  user to the "View query plan" section which has instructions for
  checking whether their query will be run with the optimizer.  When the
  heuristic planner is removed, this section can go away.

- Further deemphasize the heuristic planner by:

   - No longer mentioning that the optimizer is "Enabled by default",
     since its use is assumed in 2.2+.

   - Moving the instructions for turning off the CBO to the bottom of
     the page.
@rmloveland rmloveland mentioned this issue Jan 14, 2019
Merged
rmloveland added a commit that referenced this issue Jan 14, 2019
@rmloveland
Update optimizer docs for 20190114 alpha
6fcaad0 
Fixes #3996, #3998, #4238.

Summary of changes:

- Add section about table statistics, including:

   - How to generate statistics manually

   - How to use the new automatic statistics feature

- Add section describing the new query plan cache and how to use it.

- Add section listing the types of statements supported by the
  optimizer.  This is not exhaustive, but is meant to be a quick list of
  the types of statements supported by the optimizer.  It points the
  user to the "View query plan" section which has instructions for
  checking whether their query will be run with the optimizer.  When the
  heuristic planner is removed, this section can go away.

- Further deemphasize the heuristic planner by:

   - No longer mentioning that the optimizer is "Enabled by default",
     since its use is assumed in 2.2+.

   - Moving the instructions for turning off the CBO to the bottom of
     the page.
rmloveland added a commit that referenced this issue Jan 15, 2019
@rmloveland
Update optimizer docs for 20190115 alpha
62d2731 
Fixes #3996, #3998, #4238.

Summary of changes:

- Add section about table statistics, including:

   - How to generate statistics manually

   - How to use the new automatic statistics feature

- Add section describing the new query plan cache and how to use it.

- Add section listing the types of statements supported by the
  optimizer.  This is not exhaustive, but is meant to be a quick list of
  the types of statements supported by the optimizer.  It points the
  user to the "View query plan" section which has instructions for
  checking whether their query will be run with the optimizer.  When the
  heuristic planner is removed, this section can go away.

- Further deemphasize the heuristic planner by:

   - No longer mentioning that the optimizer is "Enabled by default",
     since its use is assumed in 2.2+.

   - Moving the instructions for turning off the CBO to the bottom of
     the page.
rmloveland added a commit that referenced this issue Jan 16, 2019
@rmloveland
Update optimizer docs for 20190115 alpha
255886d 
Fixes #3996, #3998, #4238.

Summary of changes:

- Add section about table statistics, including:

   - How to generate statistics manually

   - How to use the new automatic statistics feature

- Add section describing the new query plan cache and how to use it.

- Add section listing the types of statements supported by the
  optimizer.  This is not exhaustive, but is meant to be a quick list of
  the types of statements supported by the optimizer.  It points the
  user to the "View query plan" section which has instructions for
  checking whether their query will be run with the optimizer.  When the
  heuristic planner is removed, this section can go away.

- Further deemphasize the heuristic planner by:

   - No longer mentioning that the optimizer is "Enabled by default",
     since its use is assumed in 2.2+.

   - Moving the instructions for turning off the CBO to the bottom of
     the page.
@rmloveland
Copy link
Contributor Author

This was fixed in #4239

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rmloveland rmloveland

Labels
P-0 Urgent; must be done in next 2 weeks T-enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@rmloveland