PostgreSQL : Influencing Query Execution Plan

By enabling and disabling the following parameters, we can influence the query execution plan generated by the optimizer.

true will enable

false will disable

enable_seqscan = true

enable_indexscan = true

enable_tidscan = true

enable_sort = true

enable_nestloop = true

enable_mergejoin = true

enable_hashjoin = true