Tuning query-related parameters
In this recipe, we will talk about the query planning related parameters and the associated tuning aspects.
How to do it...
The following are the query planning related parameters that usually require tuning:
These parameters can be set in the
postgresql.conf configuration file.
How it works...
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 ...