Package - postgresql-14-pg-hint-plan

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

Primary informations

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

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