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

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

Name		Name	Last commit message	Last commit date
Latest commit History 744 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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

pg_hint_plan 1.7

About

Releases

Packages

Languages

License

peter15914/pg_hint_plan

Folders and files

Latest commit

History

Repository files navigation

pg_hint_plan 1.7

About

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages