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

[MH] Automatic statistics collection for cost-based optimizer #3996

Closed
jseldess opened this issue Nov 5, 2018 · 0 comments
Closed

[MH] Automatic statistics collection for cost-based optimizer #3996

jseldess opened this issue Nov 5, 2018 · 0 comments
Assignees
@rmloveland
Labels
P-1 High priority; must be done this release
Milestone
19.1

Comments

@jseldess
Copy link
Contributor

jseldess commented Nov 5, 2018

Background: https://airtable.com/tblD3oZPLJgGhCmch/viw5Jsp2TrY3it9Yr/recVClSBf6BN84gCy
PM: @awoods187
Eng: @andy-kimball
@jseldess jseldess added this to the 2.2 milestone Nov 5, 2018
@jseldess jseldess added the P-1 High priority; must be done this release label Nov 20, 2018
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.
@jseldess jseldess modified the milestones: 2.2, 19.1 Feb 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rmloveland rmloveland

Labels
P-1 High priority; must be done this release
Projects
None yet
Milestone
19.1
Development

No branches or pull requests
2 participants
@rmloveland @jseldess