Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

cpu_index_tuple_cost

  1. 文档
  2. Query Tuning
  3. Planner Cost Constants
  4. cpu_index_tuple_cost
COPY SHARING LINK
类型: real
默认: 0.005
最低限度: 0
最大: 1.79769e+308
上下文: user
重新开始: false
Sets the planner's estimate of the cost of processing each index entry during an index scan

设置规划器对一次索引扫描中处理每一个索引项的代价估计。默认值是 0.005。

官方文件 [EN]
谢谢 PostgreSQL中文社区

搜索源代码

建议 [EN]

Decrease this slightly to make your database favor indexes slightly more.
By annotated.conf

条评论