pg_improv
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
pg_improv | 0.13.0 | OLAP | Apache-2.0 OR MIT | Rust |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 2580 | pg_improv | No | Yes | No | Yes | No | No | improv |
Commit/logical modes need preload; policies bypassed by owners.
Version
| OS / PG | PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|---|
| el8.x86_64 | PIGSTY 0.13.0 el8.x86_64.pg18 : pg_improv_18 pg_improv_18-0.13.0-1PGSTY.el8.x86_64.rpm
| PIGSTY 0.13.0 el8.x86_64.pg17 : pg_improv_17 pg_improv_17-0.13.0-1PGSTY.el8.x86_64.rpm
| PIGSTY 0.13.0 el8.x86_64.pg16 : pg_improv_16 pg_improv_16-0.13.0-1PGSTY.el8.x86_64.rpm
| PIGSTY 0.13.0 el8.x86_64.pg15 : pg_improv_15 pg_improv_15-0.13.0-1PGSTY.el8.x86_64.rpm
| N/A |
| el8.aarch64 | PIGSTY 0.13.0 el8.aarch64.pg18 : pg_improv_18 pg_improv_18-0.13.0-1PGSTY.el8.aarch64.rpm
| PIGSTY 0.13.0 el8.aarch64.pg17 : pg_improv_17 pg_improv_17-0.13.0-1PGSTY.el8.aarch64.rpm
| PIGSTY 0.13.0 el8.aarch64.pg16 : pg_improv_16 pg_improv_16-0.13.0-1PGSTY.el8.aarch64.rpm
| PIGSTY 0.13.0 el8.aarch64.pg15 : pg_improv_15 pg_improv_15-0.13.0-1PGSTY.el8.aarch64.rpm
| N/A |
| el9.x86_64 | PIGSTY 0.13.0 el9.x86_64.pg18 : pg_improv_18 pg_improv_18-0.13.0-1PGSTY.el9.x86_64.rpm
| PIGSTY 0.13.0 el9.x86_64.pg17 : pg_improv_17 pg_improv_17-0.13.0-1PGSTY.el9.x86_64.rpm
| PIGSTY 0.13.0 el9.x86_64.pg16 : pg_improv_16 pg_improv_16-0.13.0-1PGSTY.el9.x86_64.rpm
| PIGSTY 0.13.0 el9.x86_64.pg15 : pg_improv_15 pg_improv_15-0.13.0-1PGSTY.el9.x86_64.rpm
| N/A |
| el9.aarch64 | PIGSTY 0.13.0 el9.aarch64.pg18 : pg_improv_18 pg_improv_18-0.13.0-1PGSTY.el9.aarch64.rpm
| PIGSTY 0.13.0 el9.aarch64.pg17 : pg_improv_17 pg_improv_17-0.13.0-1PGSTY.el9.aarch64.rpm
| PIGSTY 0.13.0 el9.aarch64.pg16 : pg_improv_16 pg_improv_16-0.13.0-1PGSTY.el9.aarch64.rpm
| PIGSTY 0.13.0 el9.aarch64.pg15 : pg_improv_15 pg_improv_15-0.13.0-1PGSTY.el9.aarch64.rpm
| N/A |
| el10.x86_64 | PIGSTY 0.13.0 el10.x86_64.pg18 : pg_improv_18 pg_improv_18-0.13.0-1PGSTY.el10.x86_64.rpm
| PIGSTY 0.13.0 el10.x86_64.pg17 : pg_improv_17 pg_improv_17-0.13.0-1PGSTY.el10.x86_64.rpm
| PIGSTY 0.13.0 el10.x86_64.pg16 : pg_improv_16 pg_improv_16-0.13.0-1PGSTY.el10.x86_64.rpm
| PIGSTY 0.13.0 el10.x86_64.pg15 : pg_improv_15 pg_improv_15-0.13.0-1PGSTY.el10.x86_64.rpm
| N/A |
| el10.aarch64 | PIGSTY 0.13.0 el10.aarch64.pg18 : pg_improv_18 pg_improv_18-0.13.0-1PGSTY.el10.aarch64.rpm
| PIGSTY 0.13.0 el10.aarch64.pg17 : pg_improv_17 pg_improv_17-0.13.0-1PGSTY.el10.aarch64.rpm
| PIGSTY 0.13.0 el10.aarch64.pg16 : pg_improv_16 pg_improv_16-0.13.0-1PGSTY.el10.aarch64.rpm
| PIGSTY 0.13.0 el10.aarch64.pg15 : pg_improv_15 pg_improv_15-0.13.0-1PGSTY.el10.aarch64.rpm
| N/A |
| d12.x86_64 | PIGSTY 0.12.2 d12.x86_64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~bookworm_amd64.deb
| PIGSTY 0.12.2 d12.x86_64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~bookworm_amd64.deb
| PIGSTY 0.12.2 d12.x86_64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~bookworm_amd64.deb
| PIGSTY 0.12.2 d12.x86_64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~bookworm_amd64.deb
| N/A |
| d12.aarch64 | PIGSTY 0.12.2 d12.aarch64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~bookworm_arm64.deb
| PIGSTY 0.12.2 d12.aarch64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~bookworm_arm64.deb
| PIGSTY 0.12.2 d12.aarch64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~bookworm_arm64.deb
| PIGSTY 0.12.2 d12.aarch64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~bookworm_arm64.deb
| N/A |
| d13.x86_64 | PIGSTY 0.12.2 d13.x86_64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~trixie_amd64.deb
| PIGSTY 0.12.2 d13.x86_64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~trixie_amd64.deb
| PIGSTY 0.12.2 d13.x86_64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~trixie_amd64.deb
| PIGSTY 0.12.2 d13.x86_64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~trixie_amd64.deb
| N/A |
| d13.aarch64 | PIGSTY 0.12.2 d13.aarch64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~trixie_arm64.deb
| PIGSTY 0.12.2 d13.aarch64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~trixie_arm64.deb
| PIGSTY 0.12.2 d13.aarch64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~trixie_arm64.deb
| PIGSTY 0.12.2 d13.aarch64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~trixie_arm64.deb
| N/A |
| u22.x86_64 | PIGSTY 0.12.2 u22.x86_64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~jammy_amd64.deb
| PIGSTY 0.12.2 u22.x86_64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~jammy_amd64.deb
| PIGSTY 0.12.2 u22.x86_64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~jammy_amd64.deb
| PIGSTY 0.12.2 u22.x86_64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~jammy_amd64.deb
| N/A |
| u22.aarch64 | PIGSTY 0.12.2 u22.aarch64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~jammy_arm64.deb
| PIGSTY 0.12.2 u22.aarch64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~jammy_arm64.deb
| PIGSTY 0.12.2 u22.aarch64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~jammy_arm64.deb
| PIGSTY 0.12.2 u22.aarch64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~jammy_arm64.deb
| N/A |
| u24.x86_64 | PIGSTY 0.12.2 u24.x86_64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~noble_amd64.deb
| PIGSTY 0.12.2 u24.x86_64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~noble_amd64.deb
| PIGSTY 0.12.2 u24.x86_64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~noble_amd64.deb
| PIGSTY 0.12.2 u24.x86_64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~noble_amd64.deb
| N/A |
| u24.aarch64 | PIGSTY 0.12.2 u24.aarch64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~noble_arm64.deb
| PIGSTY 0.12.2 u24.aarch64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~noble_arm64.deb
| PIGSTY 0.12.2 u24.aarch64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~noble_arm64.deb
| PIGSTY 0.12.2 u24.aarch64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~noble_arm64.deb
| N/A |
| u26.x86_64 | PIGSTY 0.12.2 u26.x86_64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~resolute_amd64.deb
| PIGSTY 0.12.2 u26.x86_64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~resolute_amd64.deb
| PIGSTY 0.12.2 u26.x86_64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~resolute_amd64.deb
| PIGSTY 0.12.2 u26.x86_64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~resolute_amd64.deb
| N/A |
| u26.aarch64 | PIGSTY 0.12.2 u26.aarch64.pg18 : postgresql-18-pg-improv postgresql-18-pg-improv_0.12.2-1PGSTY~resolute_arm64.deb
| PIGSTY 0.12.2 u26.aarch64.pg17 : postgresql-17-pg-improv postgresql-17-pg-improv_0.12.2-1PGSTY~resolute_arm64.deb
| PIGSTY 0.12.2 u26.aarch64.pg16 : postgresql-16-pg-improv postgresql-16-pg-improv_0.12.2-1PGSTY~resolute_arm64.deb
| PIGSTY 0.12.2 u26.aarch64.pg15 : postgresql-15-pg-improv postgresql-15-pg-improv_0.12.2-1PGSTY~resolute_arm64.deb
| N/A |
Build
You can build the RPM / DEB packages for pg_improv using pig build:
Install
You can install pg_improv directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
Install the extension using pig or apt/yum/dnf:
Create Extension:
Usage
Sources:
pg_improv 0.13.0 binds PostgreSQL tables to multidimensional models, evaluates formulas and materializes results. It supports PostgreSQL 15–18 and requires superuser installation. This example uses manual synchronization, which works without preloading the library.
Core Workflow
Bind categories before their measures. Duplicate coordinates require an explicit aggregate; null values do not create model cells. Result tables live in a model-specific schema. improv.define accepts replace => true to replace a formula, and improv.recalc returns the number of changed result rows.
Synchronization Modes
improv.set_sync_mode chooses manual, trigger, commit or logical synchronization. Trigger mode works without preloading; commit mode needs session or server preloading. The default logical mode needs shared_preload_libraries, a server restart, wal_level=logical and the appropriate improv.database worker setting. Logical results arrive asynchronously; use explicit recalculation when a transaction must immediately see current results.
Monitor improv.status and cap retained WAL with max_slot_wal_keep_size. Logical replication slots can retain WAL while a worker stalls. Binding tables can create publications and change replica identity; account for those effects before enabling logical mode.
Formula and Maintenance Boundaries
The improv language supports scalar formulas as well as model expressions, but not arbitrary SQL calls or external I/O. Formula errors normally become null; improv.raise_errors changes that policy. Numeric values and large integers pass through floating-point evaluation, so precision beyond 2^53 needs care. improv.max_cells limits loaded input cells.
Back up model definitions and result state with database dumps and rehearse restoration; logical mode needs a fresh slot and recomputation after restore. Library upgrades require restarting preloaded processes and updating the extension SQL. Model computation is distinct from an application transaction’s source-of-truth tables.
Model Access Policies in 0.13.0
Models execute with their owner’s privileges. Grant improv_user to model creators and give them the required source-table privileges. Version 0.13.0 adds Cedar policies through improv.set_policies, inspection through improv.policies, and decision explanations through improv.explain_access.
Grant improv_reader (or improv_user) to restricted users and separately grant access to result tables. Policies filter result rows and the improv.categories, improv.items, improv.measures and improv.cells functions. Superusers, the owner and roles allowed to act as the owner bypass these policies. A model without policies retains its ordinary grant behavior; configured policies deny by default, and invalid policies deny access to restricted users.
Derived values are calculated over all owner-visible inputs before filtering. Hiding an input does not remove its contribution from an allowed total. Model policies do not restrict direct access to source tables. Permitted cell edits and policy changes are recorded in improv.policy_audit; rejected operations are logged by the server. Review grants and totals before exposing a model.
Upgrading to 0.13.0
Install matching files and restart PostgreSQL when the library is preloaded, then update each database:
The 0.12.2-to-0.13.0 migration adds the policy objects and functions without changing model rows. The release also fixes an upgrade deadlock with the logical-sync worker. Back up roles and model data and rehearse the update. Upstream now uses pgrx 0.19.3; this does not establish availability of a matching distribution package.
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)