Package: postgresql-19-pg-hint-plan Source: pg-hint-plan-19 Version: 1.9.0-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 291 Depends: postgresql-19, libc6 (>= 2.14) Breaks: postgresql-19-jit-llvm (<< 15) Homepage: https://github.com/ossc-db/pg_hint_plan Priority: optional Section: database Filename: pool/main/p/pg-hint-plan-19/postgresql-19-pg-hint-plan_1.9.0-1.pgdg22.04+1_amd64.deb Size: 118732 SHA512: 70a43000e65dcbbbcb467fa41b172cd1c34dabbf0816e0f80ea3f42341d369512f2c749b4a7f2d6b2b305f43f9044afa29d63ef048f41a82490c353e07d02fc0 SHA256: 92b57103da16c4b7a05706f9fb805e7d1284ebedd696dda32222848f38ce8135 SHA1: bd65e974593b4894debce1ef5a6be1b886b49f32 MD5sum: 540d6fb9ae1dd750abd68b72f1db8c82 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) */.