---
name: postgres-node-performance-tuning
description: Diagnose and improve PostgreSQL performance in Node.js applications with large data volumes.
---

# PostgreSQL and Node.js performance

Measure query plans and workload shape before changing code. Select only required columns, bound
result sets, paginate or stream large reads, batch writes within explicit transaction limits, and
keep connection-pool usage bounded. Validate query changes with representative cardinality and
watch latency, memory, lock time, and connection pressure together.

Consumer wrappers own schema ownership, operational thresholds, pooling configuration, and rollout.

Read [performance patterns](references/performance-patterns.md) before changing high-volume paths.