High-performance PostgreSQL 16 image with pg_ivm (Incremental View Maintenance) and PostGIS
2.4K
This repository provides Docker images for PostgreSQL 16 with pre-installed extensions for Incremental View Maintenance (pg_ivm) and PostGIS.
Standard PostgreSQL materialized views require manual refreshes. pg_ivm allows you to create views that update automatically and incrementally, significantly reducing overhead for write-heavy workloads that need real-time data analysis.
docker pull anonymouz/postgresql-ivm:latest
docker run --name pg-ivm -e POSTGRES_PASSWORD=pass -d anonymouz/postgresql-ivm:latest
-- Connect to Postgres and run:
CREATE EXTENSION pg_ivm;
CREATE EXTENSION postgis;
latest, 16-3.6-trixie — Based on Debian Trixie (current stable)16-3.5-bullseye — Based on Debian Bullseye (legacy stable)For issues, contributions, or build details, visit the GitHub repository: github.com/anonymouzz/postgres-ivm
Content type
Image
Digest
sha256:3d33b85ab…
Size
228.5 MB
Last updated
7 months ago
docker pull anonymouz/postgresql-ivm