🗄️ Database
Connection Pooling
Configure and optimize database connection pools.
TypeORM Pool Configuration
DB_POOL_SIZE=40
DB_POOL_MAX=100TypeOrmModule.forRoot({
type: "postgres",
extra: {
max: parseInt(process.env.DB_POOL_SIZE || "40"),
min: 5,
idleTimeoutMillis: 30000,
connectionTimeoutMillis: 5000,
},
});Pool Sizing Guide
| Deployment Size | Pool Size | Max | Min |
|---|---|---|---|
| Development | 5 | 10 | 1 |
| Small (< 20) | 20 | 30 | 5 |
| Medium (< 100) | 40 | 60 | 10 |
| Large (500+) | 80 | 100 | 20 |
Formula: pool_size = (cores * 2) + effective_spindle_count
PgBouncer (Connection Pooler)
For large deployments, use PgBouncer:
# pgbouncer.ini
[databases]
gauzy = host=db port=5432 dbname=gauzy
[pgbouncer]
pool_mode = transaction
default_pool_size = 50
max_client_conn = 500Docker Compose
pgbouncer:
image: edoburu/pgbouncer
environment:
DATABASE_URL: postgres://postgres:password@db:5432/gauzy
POOL_MODE: transaction
DEFAULT_POOL_SIZE: 50
ports:
- "6432:6432"Monitoring Connections
-- Active connections
SELECT count(*) FROM pg_stat_activity WHERE datname = 'gauzy';
-- Connection states
SELECT state, count(*)
FROM pg_stat_activity
WHERE datname = 'gauzy'
GROUP BY state;Related Pages
- Database Schema — schema
- Performance Benchmarks — performance
- Production Deployment — deployment