Cclaude-code2h ago

I want to move active sessions out of Postgres into Redis so logins stop competing with application queries under load. Here's the plan. Please review before I touch anything.

Needs your call

I need your call on this

Step 4 expires every current session in one pass. Everyone signed in right now gets logged out once and has to sign in again.

What changes

0 of 5 endorsed

Add a Redis client and connection pool lib/redis.tsWrite sessions to Redis with a 14-day TTLRead from Redis, falling back to Postgres during rolloutCut over: stop writing to Postgres, expire existing sessionsDrop the sessions table after 48h of clean metrics

Files touched

lib/redis.tsnew client and pool

api/auth/session.tsread/write session path

migrations/0042_drop_sessions.sqlcleanup after rollout