select open change scope Open full search

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

Extensions / Features

saio

Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO

pgext.cloud · Source code · Website · Documentation · Control file · PGXN

Overview

Packagesaio
Version0.0.1
RepositoryUnspecified
Extension typeNo DDL
Project statusPreview
Requires CREATE EXTENSIONNo
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariessaio
Stars10
Latest commit2011-11-04
Latest release2011-05-20
Catalogue updated2026-08-30

Related extensions

See also

geqo_extensionLoad-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior.
pg_py_plan_forwardingForward PostgreSQL planner and executor data to embedded Python callbacks
sr_planPlanner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates.
pathprobePostgreSQL planner path probing extension for planner-aware SQL agents
optpathsPlanner hook extension for adding paths and removing self joins
google_plan_managementPreview AlloyDB extension for tracking, approving, denying, and consistently selecting query plans.
planinstrPlanner hook for measuring PostgreSQL planning time, intended mainly for debugging.
pg_bofhRejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries.