Package - postgresql-17-pg-hint-plan

Package:  postgresql-17-pg-hint-plan
apt-get install postgresql-17-pg-hint-plan
Documentations in package:

Primary informations

Download package: https://apt.postgresql.org/pub/repos/apt/pool/main/p/pg-hint-plan-17/postgresql-17-pg-hint-plan_1.7.1-1.pgdg13+1_amd64.deb (Size: 128.4KiB)

PropertyValue
Packagepostgresql-17-pg-hint-plan
Sourcepg-hint-plan-17
Version1.7.1-1.pgdg13+1
Architectureamd64
MaintainerDebian PostgreSQL Maintainers
Installed-Size309
Dependspostgresql-17, libc6 (>= 2.14)
Homepagehttps://github.com/ossc-db/pg_hint_plan
Priorityoptional
Sectiondatabase
Filenamepool/main/p/pg-hint-plan-17/postgresql-17-pg-hint-plan_1.7.1-1.pgdg13+1_amd64.deb
Size131528
SHA2565aa7e1e4afa25f42304b3aeeb41ef3338eb36e7002e4ae0299913c795fab2c53
SHA12eecad546324e0d8b9dc8dc183f3637a01ce5dcf
MD5sumc8574ad71c177db5e2257c869e59cb57
Descriptionsupport 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) */.
Description-md5

Files in package

  • /usr/lib/postgresql/17/lib/bitcode/pg_hint_plan.index.bc
  • /usr/lib/postgresql/17/lib/bitcode/pg_hint_plan.index.bc
  • /usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/pg_hint_plan.bc
  • /usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/pg_hint_plan.bc
  • /usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/query_scan.bc
  • /usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/query_scan.bc
  • /usr/lib/postgresql/17/lib/pg_hint_plan.so
  • /usr/lib/postgresql/17/lib/pg_hint_plan.so
  • /usr/share/doc/postgresql-17-pg-hint-plan/README
  • /usr/share/doc/postgresql-17-pg-hint-plan/README
  • /usr/share/doc/postgresql-17-pg-hint-plan/changelog.Debian.amd64.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/changelog.Debian.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/changelog.Debian.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/copyright
  • /usr/share/doc/postgresql-17-pg-hint-plan/copyright
  • /usr/share/doc/postgresql-17-pg-hint-plan/description.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/description.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/errors.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/errors.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/functional_limitations.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/functional_limitations.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/hint_details.md.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/hint_details.md.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/hint_list.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/hint_list.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/hint_table.md.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/hint_table.md.gz
  • /usr/share/doc/postgresql-17-pg-hint-plan/index.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/index.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/installation.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/installation.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/requirements.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/requirements.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/synopsis.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/synopsis.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/uninstallation.md
  • /usr/share/doc/postgresql-17-pg-hint-plan/uninstallation.md
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.0--1.3.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.0--1.3.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.0.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.0.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.1--1.3.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.1--1.3.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.10--1.3.11.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.10--1.4.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.11--1.4.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.2--1.3.3.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.2--1.3.3.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.3--1.3.4.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.3--1.3.4.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.4--1.3.5.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.4--1.3.5.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.5--1.3.6.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.5--1.3.6.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.6--1.3.7.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.6--1.3.7.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.7--1.3.8.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.7--1.3.8.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.8--1.3.9.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.8--1.3.9.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.9--1.3.10.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.3.9--1.3.10.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4--1.4.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4--1.4.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.1--1.4.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.1--1.4.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.2--1.4.3.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.2--1.4.3.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.3--1.4.4.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.3--1.5.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.4.4--1.5.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5--1.5.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5--1.5.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5.1--1.5.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5.1--1.5.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5.2--1.5.3.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5.2--1.6.0.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.5.3--1.6.0.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.6.0--1.6.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.6.0--1.6.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.6.1--1.6.2.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.6.1--1.7.0.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.6.2--1.7.0.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan--1.7.0--1.7.1.sql
  • /usr/share/postgresql/17/extension/pg_hint_plan.control
  • /usr/share/postgresql/17/extension/pg_hint_plan.control