Package: postgresql-15-pg-hint-plan Source: pg-hint-plan-15 Version: 1.5.3-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 270 Depends: postgresql-15, libc6 (>= 2.14) Homepage: https://github.com/ossc-db/pg_hint_plan Priority: optional Section: database Filename: pool/main/p/pg-hint-plan-15/postgresql-15-pg-hint-plan_1.5.3-1.pgdg22.04+1_amd64.deb Size: 119872 SHA256: 7f64f8708b12ad5640d70ae34a5ce17d5ec474161028fce22c1c8841ca26f156 SHA1: 8a7c1e60cd680e0dcc995de6fa18a223676e8dec MD5sum: aff6ea093744ced38b19140685b37a93 Description: support for optimizer hints in PostgreSQL PostgreSQL uses a cost-based optimizer that uses data statistics, not static rules. The planner (optimizer) estimates costs of each possible execution plans for a SQL statement, then executes the plan with the lowest cost. The planner does its best to select the best execution plan, but it is far from perfect, since it may not count some data properties, like correlation between columns. . pg_hint_plan makes it possible to tweak PostgreSQL execution plans using so-called "hints" in SQL comments, like /*+ SeqScan(a) */.