PostgreSQL
6 guides tagged “PostgreSQL”.
- Connection Pool Exhausted: What It Is and How to Fix It Pool exhaustion means connections are held rather than missing. Learn why raising the limit makes it worse, how to find the leak, and the four real causes.
- Postgres vs MySQL: Which Should You Use? Postgres and MySQL are far closer than the folklore says. Compare them on types, JSON, constraints, and operations, and get a direct recommendation.
- SQLite vs Postgres: Which Should You Use? SQLite is fast and zero-ops but single-writer. Postgres is concurrent and multi-user. Compare them, and see why local SQLite plus prod Postgres breaks.
- How to Choose a Database for Your App: A Decision Guide Workload, consistency, data shape, scale, and ops burden — the five questions that decide which database you should use, with a comparison table and the cases where each option is wrong.
- How to Design a Database Schema (That You Won't Have to Rewrite) Design a schema from your queries, not your entities: primary keys, relationships, column types, constraints, indexes, and the migration order that survives deploy day.
- How to Run PostgreSQL on k3s (With Backups That Actually Restore) Run Postgres on a single-node k3s cluster with a StatefulSet, a PersistentVolumeClaim, and a scheduled off-node backup you have restored at least once.