Package: postgresql-18-pg-hint-plan Source: pg-hint-plan-18 Version: 1.8.0-3.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 316 Depends: postgresql-18, libc6 (>= 2.14) Breaks: postgresql-18-jit-llvm (<< 21) Homepage: https://github.com/ossc-db/pg_hint_plan Priority: optional Section: database Filename: pool/main/p/pg-hint-plan-18/postgresql-18-pg-hint-plan_1.8.0-3.pgdg26.04+1_amd64.deb Size: 133256 SHA256: da05f04b83634e99a037c20fa71181b12fdce7017d56b05451c13d8d8cc11b6d SHA1: a9726d60edb6a9388980b10118b8d3b799c03b49 MD5sum: 177d2e2f93e7575b49a4fdbd2a5308d3 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) */.