Package: postgresql-12-pg-hint-plan Source: pg-hint-plan-12 Version: 1.3.10-2.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 340 Depends: postgresql-12, libc6 (>= 2.14) Homepage: https://github.com/ossc-db/pg_hint_plan Priority: optional Section: database Filename: pool/main/p/pg-hint-plan-12/postgresql-12-pg-hint-plan_1.3.10-2.pgdg22.04+1_amd64.deb Size: 132344 SHA256: d358094bc865a025ceb96afc203a82dc84b7e705eae6d8e4bd386c68d49178ef SHA1: 963c6c5a5ce5c60827d3243e8d65cca36288145d MD5sum: 87167da328349b2a7a45d57c700f9676 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) */.