Wiki / Configuration Parameters

Sets the minimum amount of index data that must be scanned in order for a parallel scan to be considered. Note that a parallel index scan typically won't touch the entire index; it is the number of pages which the planner believes will actually be touched by the scan which is relevant. This parameter is also used to decide whether a particular index can participate in a parallel vacuum. See VACUUM. If this value is specified without units, it is taken as blocks, that is BLCKSZ bytes, typically 8kB. The default is 512 kilobytes (512kB).

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

boot val

64

category

Query Tuning / Planner Cost Constants

context

user

documented

true

enumvals

Unknown

extra desc

If the planner estimates that it will read a number of index pages too small to reach this limit, a parallel scan will not be considered.

lang

en

max val

715827882

metadata version

18

min val

0

name

min_parallel_index_scan_size

short desc

Sets the minimum amount of index data for a parallel scan.

source

pg-settings-source-snapshot

unit

8kB

vartype

integer