Package - postgresql-16-pg-hint-plan

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

Primary informations

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

PropertyValue
Packagepostgresql-16-pg-hint-plan
Sourcepg-hint-plan-16
Version1.6.2-1.pgdg13+1
Architectureamd64
MaintainerDebian PostgreSQL Maintainers
Installed-Size256
Dependspostgresql-16, libc6 (>= 2.14)
Homepagehttps://github.com/ossc-db/pg_hint_plan
Priorityoptional
Sectiondatabase
Filenamepool/main/p/pg-hint-plan-16/postgresql-16-pg-hint-plan_1.6.2-1.pgdg13+1_amd64.deb
Size107328
SHA25650b82303fe38b35c38552258b3dfb0fec0dca0ff76ac91d3733452ab6c2216e2
SHA1172f40a18a59fe6fb9e8623c116225e6d5f52ead
MD5sumf94d5ad980e19731c5f953874c9920c5
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/16/lib/bitcode/pg_hint_plan.index.bc
  • /usr/lib/postgresql/16/lib/bitcode/pg_hint_plan/pg_hint_plan.bc
  • /usr/lib/postgresql/16/lib/pg_hint_plan.so
  • /usr/share/doc/postgresql-16-pg-hint-plan/README
  • /usr/share/doc/postgresql-16-pg-hint-plan/changelog.Debian.gz
  • /usr/share/doc/postgresql-16-pg-hint-plan/copyright
  • /usr/share/doc/postgresql-16-pg-hint-plan/description.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/errors.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/functional_limitations.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/hint_details.md.gz
  • /usr/share/doc/postgresql-16-pg-hint-plan/hint_list.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/hint_table.md.gz
  • /usr/share/doc/postgresql-16-pg-hint-plan/index.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/installation.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/requirements.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/synopsis.md
  • /usr/share/doc/postgresql-16-pg-hint-plan/uninstallation.md
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.0--1.3.1.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.0.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.1--1.3.2.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.10--1.3.11.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.11--1.4.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.2--1.3.3.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.3--1.3.4.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.4--1.3.5.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.5--1.3.6.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.6--1.3.7.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.7--1.3.8.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.8--1.3.9.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.3.9--1.3.10.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.4--1.4.1.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.4.1--1.4.2.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.4.2--1.4.3.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.4.3--1.4.4.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.4.4--1.5.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.5--1.5.1.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.5.1--1.5.2.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.5.2--1.5.3.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.5.3--1.6.0.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.6.0--1.6.1.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan--1.6.1--1.6.2.sql
  • /usr/share/postgresql/16/extension/pg_hint_plan.control