Accelerated sequential scan
The accelerated sequential scan enables the database to perform most of the table scans faster than using the default sequential scan implementation.
The accelerated sequential scan displays in the query plan as S64 DA Seq Scan. Queries with high degree of parallelism benefit most from it.
Settings
- swarm64da.enable_seqscan (boolean)
-
Enables or disables the accelerated sequential scan. The default is
on. - swarm64da.cost_scan_page (floating point)
-
Sets the planner's estimate of the cost of a disk page fetch by the accelerated sequential scan. The default is
seq_page_cost / 2. - swarm64da.cost_scan_startup (floating point)
-
Sets the planner's estimate base cost to perform an accelerated sequential scan. The default is
32768 * seq_page_cost.