Wiki / Configuration Parameters

Sets the minimum amount of table data that must be scanned in order for a parallel scan to be considered. For a parallel sequential scan, the amount of table data scanned is always equal to the size of the table, but when indexes are used the amount of table data scanned will normally be less. If this value is specified without units, it is taken as blocks, that is BLCKSZ bytes, typically 8kB. The default is 8 megabytes (8MB).

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

boot val

1024

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 table 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_table_scan_size

short desc

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

source

pg-settings-source-snapshot

unit

8kB

vartype

integer