pg_hint_plan 1.7

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, 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.

For more details, please see the various documentations available in the docs/ directory:

Name		Name	Last commit message	Last commit date
Latest commit History 748 Commits
SPECS		SPECS
data		data
docs		docs
expected		expected
sql		sql
.gitattributes		.gitattributes
.gitignore		.gitignore
COPYRIGHT		COPYRIGHT
COPYRIGHT.postgresql		COPYRIGHT.postgresql
META.json		META.json
Makefile		Makefile
README.md		README.md
core.c		core.c
make_join_rel.c		make_join_rel.c
normalize_query.h		normalize_query.h
pg_hint_plan--1.3.0--1.3.1.sql		pg_hint_plan--1.3.0--1.3.1.sql
pg_hint_plan--1.3.0.sql		pg_hint_plan--1.3.0.sql
pg_hint_plan--1.3.1--1.3.2.sql		pg_hint_plan--1.3.1--1.3.2.sql
pg_hint_plan--1.3.2--1.3.3.sql		pg_hint_plan--1.3.2--1.3.3.sql
pg_hint_plan--1.3.3--1.3.4.sql		pg_hint_plan--1.3.3--1.3.4.sql
pg_hint_plan--1.3.4--1.3.5.sql		pg_hint_plan--1.3.4--1.3.5.sql
pg_hint_plan--1.3.5--1.3.6.sql		pg_hint_plan--1.3.5--1.3.6.sql
pg_hint_plan--1.3.6--1.3.7.sql		pg_hint_plan--1.3.6--1.3.7.sql
pg_hint_plan--1.3.7--1.3.8.sql		pg_hint_plan--1.3.7--1.3.8.sql
pg_hint_plan--1.3.8--1.3.9.sql		pg_hint_plan--1.3.8--1.3.9.sql
pg_hint_plan--1.3.9--1.4.sql		pg_hint_plan--1.3.9--1.4.sql
pg_hint_plan--1.4--1.4.1.sql		pg_hint_plan--1.4--1.4.1.sql
pg_hint_plan--1.4.1--1.4.2.sql		pg_hint_plan--1.4.1--1.4.2.sql
pg_hint_plan--1.4.2--1.5.sql		pg_hint_plan--1.4.2--1.5.sql
pg_hint_plan--1.5--1.5.1.sql		pg_hint_plan--1.5--1.5.1.sql
pg_hint_plan--1.5.1--1.6.0.sql		pg_hint_plan--1.5.1--1.6.0.sql
pg_hint_plan--1.6.0--1.7.0.sql		pg_hint_plan--1.6.0--1.7.0.sql
pg_hint_plan.c		pg_hint_plan.c
pg_hint_plan.control		pg_hint_plan.control
pg_stat_statements.c		pg_stat_statements.c
query_scan.h		query_scan.h
query_scan.l		query_scan.l
query_scan_int.h		query_scan_int.h
update_copied_funcs.pl		update_copied_funcs.pl

ossc-db/pg_hint_plan

Folders and files

Latest commit

History

Repository files navigation

pg_hint_plan 1.7

About

Resources

Stars

Watchers

Forks

Languages