Package - postgresql-12-pg-hint-plan

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

Primary informations

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

PropertyValue
Packagepostgresql-12-pg-hint-plan
Sourcepg-hint-plan-12
Version1.3.10-2.pgdg13+1
Architectureamd64
MaintainerDebian PostgreSQL Maintainers
Installed-Size323
Dependspostgresql-12, libc6 (>= 2.14)
Homepagehttps://github.com/ossc-db/pg_hint_plan
Priorityoptional
Sectiondatabase
Filenamepool/main/p/pg-hint-plan-12/postgresql-12-pg-hint-plan_1.3.10-2.pgdg13+1_amd64.deb
Size119528
SHA256ead3466598c6b7b2c26c56638c656c94cdd2d536215e755f98ad2d6a7013d118
SHA1c7b85d12035a04eff5b77e9e288adf82de27a9a0
MD5sum5d543cfe7463ead08efd3bbb0bf34166
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/12/lib/bitcode/pg_hint_plan.index.bc
  • /usr/lib/postgresql/12/lib/bitcode/pg_hint_plan/pg_hint_plan.bc
  • /usr/lib/postgresql/12/lib/pg_hint_plan.so
  • /usr/share/doc/postgresql-12-pg-hint-plan/changelog.Debian.gz
  • /usr/share/doc/postgresql-12-pg-hint-plan/copyright
  • /usr/share/doc/postgresql-12-pg-hint-plan/hint_list-ja.html
  • /usr/share/doc/postgresql-12-pg-hint-plan/hint_list.html
  • /usr/share/doc/postgresql-12-pg-hint-plan/pg_hint_plan-ja.html
  • /usr/share/doc/postgresql-12-pg-hint-plan/pg_hint_plan.html
  • /usr/share/doc/postgresql-12-pg-hint-plan/style.css
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.0--1.3.1.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.0.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.1--1.3.2.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.2--1.3.3.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.3--1.3.4.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.4--1.3.5.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.5--1.3.6.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.6--1.3.7.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.7--1.3.8.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.8--1.3.9.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan--1.3.9--1.3.10.sql
  • /usr/share/postgresql/12/extension/pg_hint_plan.control