cardosofelipe/syndarix
1
0
Fork 0
forked from cardosofelipe/fast-next-template
Code Issues 18 Pull Requests Wiki Activity

Configure pgvector extension for PostgreSQL #19

New Issue
Closed
opened 2025-12-29 23:45:59 +00:00 by cardosofelipe · 0 comments
cardosofelipe commented 2025-12-29 23:45:59 +00:00
Owner
Copy Link

Description

Set up pgvector extension for vector similarity search (RAG knowledge base).

Requirements

Database Configuration

  • Use pgvector/pgvector:pg17 Docker image
  • Enable pgvector extension via migration
  • Create vector index configuration utilities

Migration

  • Create migration to enable pgvector extension
  • Document vector dimension choices (1536 for OpenAI, 1024 for Cohere)

Testing

  • Verify extension loads correctly
  • Test basic vector operations

Acceptance Criteria

  • Docker Compose uses pgvector image
  • Migration enables pgvector extension
  • Vector operations working (cosine similarity)
  • Health check includes pgvector status
  • Documentation for vector dimension choices

Technical Notes

  • Reference: ADR-007 (pgvector for RAG)
  • Reference: SPIKE-006 (pgvector RAG research)
  • Default to 1536 dimensions (OpenAI embedding size)

Assignable To

devops-engineer agent (Docker), backend-engineer agent (migration)

## Description Set up pgvector extension for vector similarity search (RAG knowledge base). ## Requirements ### Database Configuration - Use `pgvector/pgvector:pg17` Docker image - Enable pgvector extension via migration - Create vector index configuration utilities ### Migration - Create migration to enable pgvector extension - Document vector dimension choices (1536 for OpenAI, 1024 for Cohere) ### Testing - Verify extension loads correctly - Test basic vector operations ## Acceptance Criteria - [ ] Docker Compose uses pgvector image - [ ] Migration enables pgvector extension - [ ] Vector operations working (cosine similarity) - [ ] Health check includes pgvector status - [ ] Documentation for vector dimension choices ## Technical Notes - Reference: ADR-007 (pgvector for RAG) - Reference: SPIKE-006 (pgvector RAG research) - Default to 1536 dimensions (OpenAI embedding size) ## Assignable To devops-engineer agent (Docker), backend-engineer agent (migration)
cardosofelipe added the databasedevopsphase-0 labels 2025-12-29 23:49:39 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
agents
Agent orchestration
 architecture
Architectural decisions
 backend
Backend work
 blocked
Blocked by dependency
 database
Database/migrations
 design
UI/UX design work
 devops
DevOps/Infrastructure work
 epic
Epic/parent issue
 frontend
Frontend work
 infrastructure
Infrastructure / DevOps
 mcp
MCP related
 phase-0
Phase 0: Foundation
 phase-1
Phase 1: Core Platform
 phase-2
Phase 2: MCP Integration
 priority:high
High priority
 spike
Architecture spike / research task
No Label database devops phase-0
Milestone
No items
No Milestone
Assignees
Clear assignees
cardosofelipe
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: cardosofelipe/syndarix#19
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?