cubeplex/postgresql-pgroonga-pgvector repository overview

docker run --rm -e POSTGRES_PASSWORD=postgres -p 5432:5432 \
  cubeplex/postgresql-pgroonga-pgvector:latest

CREATE EXTENSION IF NOT EXISTS pgroonga;
CREATE EXTENSION IF NOT EXISTS vector;

services:
  postgresql:
    image: cubeplex/postgresql-pgroonga-pgvector:latest
    ports:
      - "5432:5432"
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: postgres
    volumes:
      - pgdata:/var/lib/postgresql
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres"]
      interval: 10s
      timeout: 5s
      retries: 5

volumes:
  pgdata:

cubeplex/postgresql-pgroonga-pgvector:18.4-pgroonga4.0.8-pgvector0.8.6

CREATE EXTENSION IF NOT EXISTS pgroonga;
CREATE EXTENSION IF NOT EXISTS vector;

-- Full-text search
CREATE TABLE docs (
  id bigserial PRIMARY KEY,
  body text
);
CREATE INDEX docs_body_pgroonga ON docs USING pgroonga (body);

-- Vectors
CREATE TABLE items (
  id bigserial PRIMARY KEY,
  embedding vector(3)
);
CREATE INDEX items_embedding_ivfflat ON items
  USING ivfflat (embedding vector_l2_ops) WITH (lists = 100);