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 .