PostgreSQL: Documentation: 9.2: Query Planning

Search Documentation: Home → Documentation → Manuals → PostgreSQL 9.2 This page in other versions: 9.0 / 9.1 / 9.2 / 9.3 / 9.4 |  Development versions: devel |  Unsupported versions: 8.1 / 8.2 / 8.3 / 8.4 PostgreSQL 9.2.9 Documentation Prev Up Chapter 18. Server Configuration Next 18.7. Query Planning 18.7.1. Planner Method Configuration These configuration parameters provide a crude method of influencing the query plans chosen by the query optimizer. If the default plan chosen by the optimizer for a particular query is not optimal, a temporary solution is to use one of these configuration parameters to force the optimizer to choose a different plan. Better ways to improve the quality of the plans chosen by the optimizer include adjusting the planer cost constants (see Section 18.7.2 ), running ANALYZE...

Linked on 2015-01-08 23:04:17 | Similar Links