Query rewriting extension that transparently rewrites queries to use lower-cost materialized views.
pgext.cloud · Source code · Documentation · Control file
| Package | pg_fdw_mv_rewrite |
|---|---|
| Version | 0.6.2 |
| Repository | Unspecified |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | No |
| Shared libraries | mv_rewrite.0.6.2 |
| Schema | mv_rewrite |
| Stars | 10 |
| Latest commit | 2019-07-29 |
| Latest release | 2018-06-17 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| mv_stats | Tracks creation, alteration, refresh, and reset statistics for materialized views. |
| kilobase | Preloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views. |
| pg_stash_advice | Store plan advice by query ID and automatically apply it during PostgreSQL query planning |
| optpaths | Planner hook extension for adding paths and removing self joins |
| pargres | Prototype parallel query execution module for shared-nothing PostgreSQL clusters |
| pg_bofh | Rejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. |
| pathprobe | PostgreSQL planner path probing extension for planner-aware SQL agents |
| planinstr | Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. |