INFO
Name: pg_hint_plan_17
Version: 1.7.0-3PGDG.rhel9
Arch: ppc64le
Summary: Tweak PostgreSQL execution plans using so-called "hints" in SQL comments
License: MIT
Vendor: PostgreSQL Global Development Group
Build Host: pgrpms-el9-ppc64le.postgresql.org
Build Date: Sat Mar 8 03:57:49 2025
Size: 147509
URL: https://github.com/ossc-db/pg_hint_plan/
Description: pg_hint_plan makes it possible to tweak PostgreSQL execution plans using
so-called "hints" in SQL comments, like /*+ SeqScan(a) */.
PostgreSQL uses a cost-based optimizer, which utilizes data statistics,
not static rules. The planner (optimizer) esitimates costs of each possible
execution plans for a SQL statement then the execution plan with the lowest
cost finally be executed. The planner does its best to select the best best
execution plan, but is not always perfect, since it doesn't count some
properties of the data, for example, correlation between columns.
FILES
/usr/lib/.build-id
/usr/lib/.build-id/d5
/usr/lib/.build-id/d5/9887b38cf1c0043a432b07138af88ea377f7ae
/usr/pgsql-17/doc/extension/README-pg_hint_plan.md
/usr/pgsql-17/lib/pg_hint_plan.so
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.0--1.3.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.0.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.1--1.3.2.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.10--1.4.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.2--1.3.3.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.3--1.3.4.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.4--1.3.5.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.5--1.3.6.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.6--1.3.7.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.7--1.3.8.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.8--1.3.9.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.9--1.3.10.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4--1.4.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4.1--1.4.2.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4.2--1.4.3.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4.3--1.5.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.5--1.5.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.5.1--1.5.2.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.5.2--1.6.0.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.6.0--1.6.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.6.1--1.7.0.sql
/usr/pgsql-17/share/extension/pg_hint_plan.control
REQUIRES
libc.so.6()(64bit)
libc.so.6(GLIBC_2.17)(64bit)
postgresql17-server
rpmlib(CompressedFileNames) 3.0.4-1
rpmlib(FileDigests) 4.6.0-1
rpmlib(PayloadFilesHavePrefix) 4.0-1
rpmlib(PayloadIsZstd) 5.4.18-1
rtld(GNU_HASH)
PROVIDES
pg_hint_plan_17 1.7.0-3PGDG.rhel9
pg_hint_plan_17(ppc-64) 1.7.0-3PGDG.rhel9
CONFIG FILES
/usr/lib/.build-id a
/usr/lib/.build-id/d5 a
/usr/lib/.build-id/d5/9887b38cf1c0043a432b07138af88ea377f7ae a
/usr/pgsql-17/doc/extension/README-pg_hint_plan.md d
/usr/pgsql-17/lib/pg_hint_plan.so
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.0--1.3.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.0.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.1--1.3.2.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.10--1.4.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.2--1.3.3.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.3--1.3.4.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.4--1.3.5.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.5--1.3.6.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.6--1.3.7.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.7--1.3.8.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.8--1.3.9.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.3.9--1.3.10.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4--1.4.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4.1--1.4.2.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4.2--1.4.3.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.4.3--1.5.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.5--1.5.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.5.1--1.5.2.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.5.2--1.6.0.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.6.0--1.6.1.sql
/usr/pgsql-17/share/extension/pg_hint_plan--1.6.1--1.7.0.sql
/usr/pgsql-17/share/extension/pg_hint_plan.control
LICENSE FILES
MIT
|
