select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Features

optpaths

Planner hook extension for adding paths and removing self joins

pgext.cloud · Source code · Documentation · License text · Control file

Overview

PackageanotherSelfJoin
Version0.1
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariesoptpaths
Stars3
Latest commit2019-10-23
Catalogue updated2026-08-30

Related extensions

See also

pg_bofhRejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries.
geqo_extensionLoad-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior.
planinstrPlanner hook for measuring PostgreSQL planning time, intended mainly for debugging.
pathprobePostgreSQL planner path probing extension for planner-aware SQL agents
mv_rewriteQuery rewriting extension that transparently rewrites queries to use lower-cost materialized views.
pargresPrototype parallel query execution module for shared-nothing PostgreSQL clusters
pg_stash_adviceStore plan advice by query ID and automatically apply it during PostgreSQL query planning
pg_table_rangePlanning-time partition pruning by per-partition data ranges, including non-key columns.