In this recipe, we will talk about the query planning related parameters and the associated tuning aspects.
The following are the query planning related parameters that usually require tuning:
These parameters can be set in the
postgresql.conf configuration file.
random_page_cost: This parameter is basically used to estimate the cost of a random page fetch in abstract cost units. The default value of this parameter is 4.0. Random page cost is basically used to represent the coefficient between the cost of looking up one row via sequential scans against the cost of looking up a single row individually using ...