Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

The query plan

Andrey Lepikhov edited this pageFeb 21, 2020 ·1 revision

Why are we not get the optimal query plan?

  1. Planner get incorrect cost estimations for plan nodes.
  2. GEQO algorithm can't achieve global optimum.

If we use AQO we have correct estimations for each node of executed plan. But not all of paths are executed because of poor estimations (may be correct or not).If AQO will give positive predictions for the not known nodes, we will got optimal query plan in the case of base_search algorithm.With GEQO algorithm we have not any guarantees, but we can touch geqo_seed, geqo_effort GUC's. In this case we have more chances to find out an optimal plan.

Clone this wiki locally

[8]ページ先頭

©2009-2025 Movatter.jp