Sizing & Deployment Guide

Production capacity formulas, infrastructure sizing tiers, and Docker Compose configurations.

Infrastructure Sizing Matrix

Tier	Concurrent Users	SKUs & Dispatches	Compute / RAM	Database Specs
Small	1 – 50	Up to 10,000 SKUs	2 vCPU / 4 GB RAM	PostgreSQL 16 (20 max connections)
Medium (HA)	50 – 500	Up to 100,000 SKUs	4 vCPU / 16 GB RAM	PostgreSQL 16 HA Replica (80 conn)
Enterprise Cluster	500+	Unlimited SKUs	8+ vCPU / 32 GB RAM	Managed PostgreSQL + PgBouncer

Production Docker Compose Deployment

version: "3.8"
services:
  syncventory:
    build: .
    ports:
      - "8080:8080"
    environment:
      - NODE_ENV=production
      - DATABASE_URL=postgres://user:password@db:5432/syncventory
      - PORT=8080
    depends_on:
      - db
    restart: always

  db:
    image: postgres:16-alpine
    environment:
      POSTGRES_USER: user
      POSTGRES_PASSWORD: password
      POSTGRES_DB: syncventory
    volumes:
      - pgdata:/var/lib/postgresql/data
    restart: always

volumes:
  pgdata: