pg-ivm
pg_ivm
pg_ivm is an open-source extension that provides Incremental View Maintenance (IVM) for PostgreSQL, allowing materialized views to be updated incrementally when base tables change.
Usage
1. Add the pg_ivm extension image to your Cluster
Define the pg_ivm extension under the postgresql.extensions section of
your Cluster resource. Note: pg_ivm must be loaded via shared_preload_libraries
for its trigger-based IVM functionality to work correctly. For example:
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: cluster-pg-ivm
spec:
imageName: ghcr.io/cloudnative-pg/postgresql:18-minimal-trixie
instances: 1
storage:
size: 1Gi
postgresql:
shared_preload_libraries:
- “pg_ivm”
extensions:
- name: pg_ivm
image:
# renovate: suite=trixie-pgdg depName=postgresql-18-pg-ivm
reference: ghcr.io/cloudnative-pg/pg-ivm:1.17-18-trixie
2. Enable the extension in a database
You can install pg_ivm in a specific database by creating or updating a
Database resource. For example, to enable it in the app database:
apiVersion: postgresql.cnpg.io/v1
kind: Database
metadata:
name: cluster-pg-ivm-app
spec:
name: app
owner: app
cluster:
name: cluster-pg-ivm
extensions:
- name: pg_ivm
# renovate: suite=trixie-pgdg depName=postgresql-18-pg-ivm extractVersion=^(?<version>\d+\.\d+)
version: '1.17'
3. Verify installation
Once the database is ready, connect to it with psql and run:
\dx
You should see pg_ivm listed among the installed extensions.
Contributors
This extension is maintained by:
- Husn E Rabbi (@shusaan)
The maintainers are responsible for:
- Monitoring upstream releases and security vulnerabilities.
- Ensuring compatibility with supported PostgreSQL versions.
- Reviewing and merging contributions specific to this extension's container image and lifecycle.
Licenses and Copyright
This container image contains software that may be licensed under various open-source licenses.
All relevant license and copyright information for the pg_ivm extension
and its dependencies are bundled within the image at:
/licenses/
By using this image, you agree to comply with the terms of the licenses contained therein.
Overview
pg_ivm is an open-source extension that provides Incremental View Maintenance (IVM) for PostgreSQL, allowing materialized views to be updated incrementally when base tables change.
Package details
- Extension version
- 1.17
- Image built
- Publisher
- cloudnative-pg
- Build
- Debian
- Platform
- PG 18 · Trixie · amd64
Project links
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_ivm;- SQL version
1.17
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_ivm' |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-WorkflowUnknown
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no workflows found
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-Protection0
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: branch protection not enabled on development/release branches
- Warn: branch protection not enabled for branch 'main'
Code-Review1
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 3/27 approved changesets -- score normalized to 1
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 15 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10
Token-PermissionsUnknown
Determines if the project's workflows follow the principle of least privilege.
Reasoning: No tokens found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-DependenciesUnknown
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: no dependencies found
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 20 are checked with a SAST tool
Security-Policy0
Determines if the project has published a security policy.
Reasoning: security policy file not detected
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
CI-Tests0
Determines if the project runs tests before pull requests are merged.
Reasoning: 0 out of 17 merged PRs checked by a CI test -- score normalized to 0
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors3
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 1 contributing companies or organizations -- score normalized to 3
- Info: found contributions from: sraoss
License9
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Warn: project license file does not contain an FSF or OSI license.
Overview
pg_ivm is an open-source extension that provides Incremental View Maintenance (IVM) for PostgreSQL, allowing materialized views to be updated incrementally when base tables change.
Package details
- Extension version
- 1.17
- Image built
- Publisher
- cloudnative-pg
- Build
- Debian
- Platform
- PG 18 · Trixie · arm64
Project links
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_ivm;- SQL version
1.17
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_ivm' |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-WorkflowUnknown
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no workflows found
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-Protection0
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: branch protection not enabled on development/release branches
- Warn: branch protection not enabled for branch 'main'
Code-Review1
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 3/27 approved changesets -- score normalized to 1
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 15 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10
Token-PermissionsUnknown
Determines if the project's workflows follow the principle of least privilege.
Reasoning: No tokens found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-DependenciesUnknown
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: no dependencies found
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 20 are checked with a SAST tool
Security-Policy0
Determines if the project has published a security policy.
Reasoning: security policy file not detected
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
CI-Tests0
Determines if the project runs tests before pull requests are merged.
Reasoning: 0 out of 17 merged PRs checked by a CI test -- score normalized to 0
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors3
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 1 contributing companies or organizations -- score normalized to 3
- Info: found contributions from: sraoss
License9
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Warn: project license file does not contain an FSF or OSI license.
Overview
pg_ivm is an open-source extension that provides Incremental View Maintenance (IVM) for PostgreSQL, allowing materialized views to be updated incrementally when base tables change.
Package details
- Extension version
- 1.17
- Image built
- Publisher
- cloudnative-pg
- Build
- Debian
- Platform
- PG 18 · Bookworm · amd64
Project links
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_ivm;- SQL version
1.17
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_ivm' |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-WorkflowUnknown
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no workflows found
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-Protection0
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: branch protection not enabled on development/release branches
- Warn: branch protection not enabled for branch 'main'
Code-Review1
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 3/27 approved changesets -- score normalized to 1
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 15 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10
Token-PermissionsUnknown
Determines if the project's workflows follow the principle of least privilege.
Reasoning: No tokens found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-DependenciesUnknown
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: no dependencies found
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 20 are checked with a SAST tool
Security-Policy0
Determines if the project has published a security policy.
Reasoning: security policy file not detected
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
CI-Tests0
Determines if the project runs tests before pull requests are merged.
Reasoning: 0 out of 17 merged PRs checked by a CI test -- score normalized to 0
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors3
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 1 contributing companies or organizations -- score normalized to 3
- Info: found contributions from: sraoss
License9
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Warn: project license file does not contain an FSF or OSI license.
Overview
pg_ivm is an open-source extension that provides Incremental View Maintenance (IVM) for PostgreSQL, allowing materialized views to be updated incrementally when base tables change.
Package details
- Extension version
- 1.17
- Image built
- Publisher
- cloudnative-pg
- Build
- Debian
- Platform
- PG 18 · Bookworm · arm64
Project links
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_ivm;- SQL version
1.17
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_ivm' |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-WorkflowUnknown
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no workflows found
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-Protection0
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: branch protection not enabled on development/release branches
- Warn: branch protection not enabled for branch 'main'
Code-Review1
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 3/27 approved changesets -- score normalized to 1
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 15 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10
Token-PermissionsUnknown
Determines if the project's workflows follow the principle of least privilege.
Reasoning: No tokens found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-DependenciesUnknown
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: no dependencies found
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 20 are checked with a SAST tool
Security-Policy0
Determines if the project has published a security policy.
Reasoning: security policy file not detected
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
CI-Tests0
Determines if the project runs tests before pull requests are merged.
Reasoning: 0 out of 17 merged PRs checked by a CI test -- score normalized to 0
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors3
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 1 contributing companies or organizations -- score normalized to 3
- Info: found contributions from: sraoss
License9
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Warn: project license file does not contain an FSF or OSI license.
Dependencies
Packages shipped in this image, including the extension itself.
This image is published by CloudNativePG. A reliable SBOM inventory of its shipped dependencies is not available yet.
Dependencies
Packages shipped in this image, including the extension itself.
This image is published by CloudNativePG. A reliable SBOM inventory of its shipped dependencies is not available yet.
Dependencies
Packages shipped in this image, including the extension itself.
This image is published by CloudNativePG. A reliable SBOM inventory of its shipped dependencies is not available yet.
Dependencies
Packages shipped in this image, including the extension itself.
This image is published by CloudNativePG. A reliable SBOM inventory of its shipped dependencies is not available yet.
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-ivm/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
Upstream-Name: pg_ivm
Source: https://github.com/sraoss/pg_ivm
Files: *
Copyright: Portions Copyright (c) 2022-2023, IVM Development Group
Portions Copyright (c) 1996-2022, PostgreSQL Global Development Group
License: postgresql
License: postgresql
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement is
hereby granted, provided that the above copyright notice and this paragraph
and the following two paragraphs appear in all copies.
.
IN NO EVENT SHALL THE AUTHORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT,
SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING
OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHORS
HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
.
THE AUTHORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMITED
TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE
AUTHORS HAVE NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES,
ENHANCEMENTS, OR MODIFICATIONS.
SHA256: c74bf5c8354de61d959acfc01364bae913674e82d1c7e2a7a0e1145453545309
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-ivm/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
Upstream-Name: pg_ivm
Source: https://github.com/sraoss/pg_ivm
Files: *
Copyright: Portions Copyright (c) 2022-2023, IVM Development Group
Portions Copyright (c) 1996-2022, PostgreSQL Global Development Group
License: postgresql
License: postgresql
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement is
hereby granted, provided that the above copyright notice and this paragraph
and the following two paragraphs appear in all copies.
.
IN NO EVENT SHALL THE AUTHORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT,
SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING
OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHORS
HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
.
THE AUTHORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMITED
TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE
AUTHORS HAVE NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES,
ENHANCEMENTS, OR MODIFICATIONS.
SHA256: c74bf5c8354de61d959acfc01364bae913674e82d1c7e2a7a0e1145453545309
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-ivm/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
Upstream-Name: pg_ivm
Source: https://github.com/sraoss/pg_ivm
Files: *
Copyright: Portions Copyright (c) 2022-2023, IVM Development Group
Portions Copyright (c) 1996-2022, PostgreSQL Global Development Group
License: postgresql
License: postgresql
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement is
hereby granted, provided that the above copyright notice and this paragraph
and the following two paragraphs appear in all copies.
.
IN NO EVENT SHALL THE AUTHORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT,
SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING
OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHORS
HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
.
THE AUTHORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMITED
TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE
AUTHORS HAVE NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES,
ENHANCEMENTS, OR MODIFICATIONS.
SHA256: c74bf5c8354de61d959acfc01364bae913674e82d1c7e2a7a0e1145453545309
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-ivm/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
Upstream-Name: pg_ivm
Source: https://github.com/sraoss/pg_ivm
Files: *
Copyright: Portions Copyright (c) 2022-2023, IVM Development Group
Portions Copyright (c) 1996-2022, PostgreSQL Global Development Group
License: postgresql
License: postgresql
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement is
hereby granted, provided that the above copyright notice and this paragraph
and the following two paragraphs appear in all copies.
.
IN NO EVENT SHALL THE AUTHORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT,
SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING
OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHORS
HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
.
THE AUTHORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMITED
TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE
AUTHORS HAVE NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES,
ENHANCEMENTS, OR MODIFICATIONS.
SHA256: c74bf5c8354de61d959acfc01364bae913674e82d1c7e2a7a0e1145453545309
Versions
Extension versions and the images built from them.
Tagged GHCR builds fetched .
