Sign inSign up

anonymouz/postgresql-ivm

By anonymouz

Updated 7 months ago

High-performance PostgreSQL 16 image with pg_ivm (Incremental View Maintenance) and PostGIS

Image
Databases & storage
0

2.4K

anonymouz/postgresql-ivm repository overview

PostgreSQL with pg_ivm & PostGIS

This repository provides Docker images for PostgreSQL 16 with pre-installed extensions for Incremental View Maintenance (pg_ivm) and PostGIS.

Why use this image?

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.

Architectures
  • linux/amd64 (Standard 64-bit)
  • linux/arm64 (Apple Silicon, Raspberry Pi 4, AWS Graviton)
How to use
docker pull anonymouz/postgresql-ivm:latest
docker run --name pg-ivm -e POSTGRES_PASSWORD=pass -d anonymouz/postgresql-ivm:latest

Enabling Extensions
-- Connect to Postgres and run:
CREATE EXTENSION pg_ivm;
CREATE EXTENSION postgis;

Tags
  • latest, 16-3.6-trixie — Based on Debian Trixie (current stable)
  • 16-3.5-bullseye — Based on Debian Bullseye (legacy stable)
Source & Feedback

For issues, contributions, or build details, visit the GitHub repository: github.com/anonymouzz/postgres-ivm

Tag summary

Content type

Image

Digest

sha256:3d33b85ab

Size

228.5 MB

Last updated

7 months ago

docker pull anonymouz/postgresql-ivm