cursor_tuple_fraction
Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. The default is 0.1. Smaller values of this setting bias the planner towards using “fast start” plans for cursors, which will retrieve the first few rows quickly while perhaps taking a long time to fetch all rows. Larger values put more emphasis on the total estimated time. At the maximum setting of 1.0, cursors are planned exactly like regular queries, considering only the total estimated time and not how soon the first rows might be delivered.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- 0.1
- category
- Query Tuning / Other Planner Options
- context
- user
- documented
- true
- enumvals
- 未知
- extra desc
- 未知
- lang
- en
- max val
- 1
- metadata version
- 18
- min val
- 0
- name
- cursor_tuple_fraction
- short desc
- Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
- source
- pg-settings-source-snapshot
- unit
- 未知
- vartype
- real
版本定义 PG 18
Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. The default is 0.1. Smaller values of this setting bias the planner towards using “fast start” plans for cursors, which will retrieve the first few rows quickly while perhaps taking a long time to fetch all rows. Larger values put more emphasis on the total estimated time. At the maximum setting of 1.0, cursors are planned exactly like regular queries, considering only the total estimated time and not how soon the first rows might be delivered.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:81780fb65115fe2a6055d4630f0445207d389873bbeb9f5f2148277e18c20ee9
正文语言: en · english-manuals:81780fb65115fe2a6055d4630f0445207d389873bbeb9f5f2148277e18c20ee9