pgqueuer/docker-compose.yml at main · janbjorge/pgqueuer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
services:

  # --- PostgreSQL ------------------------------------------------------------
  db:
    image: postgres:${POSTGRES_VERSION:-16}
    restart: "no"
    ports:
      - "5432:5432"
    tmpfs:
      - /var/lib/pg/data
    environment:
      POSTGRES_USER: pgquser
      POSTGRES_PASSWORD: pgqpw
      POSTGRES_DB: pgqdb
      PGDATA: /var/lib/pg/data
      POSTGRES_INITDB_ARGS: >-
        --encoding=UTF8
        -c jit=off
        -c synchronous_commit=off
        -c full_page_writes=off
        -c fsync=off
        -c checkpoint_timeout=30min
        -c max_wal_size=4GB
        -c checkpoint_completion_target=0.9
        -c shared_buffers=256MB
        -c vacuum_buffer_usage_limit=8MB
        -c autovacuum_naptime=5s
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U pgquser -d pgqdb || exit 1"]
      interval: 250ms
      retries: 10

  # --- Schema setup ----------------------------------------------------------
  populate:
    build: .
    working_dir: /app
    restart: "no"
    environment:
      PGUSER: pgquser
      PGPASSWORD: pgqpw
      PGDATABASE: pgqdb
      PGHOST: db
      PGPORT: 5432
    depends_on:
      db:
        condition: service_healthy
    command: >
      /bin/sh -c "(uv -n run --frozen pgq install || uv -n run --frozen pgq autovac); exit 0"

  # --- Test suite ------------------------------------------------------------
  test:
    build: .
    working_dir: /app
    restart: "no"
    environment:
      PGUSER: pgquser
      PGPASSWORD: pgqpw
      PGDATABASE: pgqdb
      PGHOST: db
      PGPORT: 5432
    depends_on:
      populate:
        condition: service_completed_successfully
    command: uv -n run --frozen pytest

  # --- Benchmark -------------------------------------------------------------
  benchmark:
    build: .
    working_dir: /app
    restart: "no"
    environment:
      PGUSER: pgquser
      PGPASSWORD: pgqpw
      PGDATABASE: pgqdb
      PGHOST: db
      PGPORT: 5432
    depends_on:
      populate:
        condition: service_completed_successfully
    command: uv -n run --frozen tools/benchmark.py