Skip to content

README.md

Latest commit

 

History

History
69 lines (53 loc) · 1.96 KB

README.md

File metadata and controls

69 lines (53 loc) · 1.96 KB

Constructive DB

The official Docker image for the Constructive database.

constructive

Lean PostgreSQL 18 image with essential extensions for modern applications.

Extensions

Extension Version Description
pgvector 0.8.2 Vector similarity search for embeddings
PostGIS 3.6.2 Spatial and geographic data
pg_textsearch 1.2.0 BM25 full-text search
pg_cron 1.6.7 Job scheduler for periodic tasks
pg_partman 5.4.3 Partition management
pg_stat_statements built-in Query performance statistics

Usage

# Pull the image
docker pull constructiveio/postgres-plus:latest

# Run
docker run -d \
  --name postgres \
  -e POSTGRES_PASSWORD=secret \
  -p 5432:5432 \
  constructiveio/postgres-plus:latest

Enable extensions as needed:

CREATE EXTENSION vector;
CREATE EXTENSION postgis;
CREATE EXTENSION pg_textsearch;
CREATE EXTENSION pg_cron;
CREATE EXTENSION pg_partman;
CREATE EXTENSION pg_stat_statements;

Configuration

track_io_timing is enabled by default for accurate I/O metrics in pg_stat_statements. This powers the usage metering and query stats collection pipeline.

Build

make build    # Build image
make test     # Build and verify extensions
make run      # Run container
make shell    # psql into container
make clean    # Remove image

Building manually

docker buildx build \
  --platform linux/amd64,linux/arm64 \
  -t constructiveio/postgres-plus:18 \
  -t constructiveio/postgres-plus:latest \
  --push .