# PostgreSQL for the three-self-joins-versus-a lab.
services:
  postgres:
    image: postgres:17.6
    command: ["postgres", "-c", "shared_buffers=512MB", "-c", "work_mem=64MB"]
    environment:
      POSTGRES_PASSWORD: lab
    ports: ["56002:5432"]
    healthcheck:
      test: ["CMD", "pg_isready", "-U", "postgres"]
      interval: 1s
      retries: 30