Wiki / Configuration Parameters

Sets the planner's estimate of the average size of the working table of a recursive query, as a multiple of the estimated size of the initial non-recursive term of the query. This helps the planner choose the most appropriate method for joining the working table to the query's other tables. The default value is 10.0. A smaller value such as 1.0 can be helpful when the recursion has low “fan-out” from one step to the next, as for example in shortest-path queries. Graph analytics queries may benefit from larger-than-default values.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

10

category

Query Tuning / Other Planner Options

context

user

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

1e+06

metadata version

18

min val

0.001

name

recursive_worktable_factor

short desc

Sets the planner's estimate of the average size of a recursive query's working table.

source

pg-settings-source-snapshot

unit

Unknown

vartype

real