Shared PostgreSQL + pgvector for Brain and Paperclip

Decision

Single paperclip-postgres container (pgvector/pgvector:pg17) hosting database cios (Brain tables) and database paperclip (Paperclip tables)

Rationale

Avoids duplicate PostgreSQL overhead. Brain needs full-text search (tsvector + GIN) and vector embeddings (pgvector ivfflat). Both services already share the same Docker network. Single backup point. cios user has access to both databases.

Alternatives Rejected

Rejected: (1) Separate databases — doubled memory/management, (2) SQLite — no FTS+vector combo, (3) External managed DB — latency and cost

Outcome

Pending