select open change scope Open full search

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

Extensions / Analytics

pgrollup

create rollup tables for fast aggregate queries

pgext.cloud · Source code · Documentation · Control file

Overview

Packagepgrollup
Version1.0
PostgreSQL versions12 · 13
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2021-04-23
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language
plpython3uPL/Python3U untrusted procedural language

See also

mv_statsTracks creation, alteration, refresh, and reset statistics for materialized views.
mv_rewriteQuery rewriting extension that transparently rewrites queries to use lower-cost materialized views.
pg_ivmincremental view maintenance on PostgreSQL
kilobasePreloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views.
pglensMaintain view-derived projection tables through an experimental manual per-key recompute API