Package: postgresql-15-pg-hint-plan Source: pg-hint-plan-15 Version: 1.5.3-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 249 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.pgdg26.04+1_amd64.deb Size: 105532 SHA256: f662b8b2b5306963e33cd2cee970a0e94d0a595197d4672e1ad40a3faba175be SHA1: 003ddb9a4397c0972cc0f4b2bda62b230ea619bf MD5sum: ef1447a7f1082404ea345c5b708fa189 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) */.