Skip to content

Topic · 68 articles

PostgreSQL

Schema, indexes, and transactions that hold under load.

PostgreSQL is the database I reach for by default, and most performance problems I see start in the schema. This hub covers data modeling, the indexes that actually get used, transaction isolation and its surprises, reading EXPLAIN output, and running migrations without downtime.

It is built around the PostgreSQL Masterclass series and links to the Databases, Redis, and NestJS hubs.

Subscribe to PostgreSQL via RSS

Follow the series

Series · 40 parts

PostgreSQL Masterclass

A deep, practical path through production PostgreSQL: data types and schema design, indexing and query performance, transactions and concurrency, JSONB and full-text search, and scaling with partitioning, replication, and backups.

Start reading

All PostgreSQL articles

The PostgreSQL Production Checklist — Aman Kumar Singh
Scaling PostgreSQL: Vertical, Read Replicas, and Sharding — Aman Kumar Singh
Monitoring PostgreSQL in Production — Aman Kumar Singh
Tuning Autovacuum for Production in PostgreSQL — Aman Kumar Singh
Backups and Point-in-Time Recovery in PostgreSQL — Aman Kumar Singh
High Availability and Failover in PostgreSQL — Aman Kumar Singh
Streaming Replication and Read Replicas in PostgreSQL — Aman Kumar Singh
Connection Pooling with PgBouncer in PostgreSQL — Aman Kumar Singh
Table Partitioning in PostgreSQL — Aman Kumar Singh
Row-Level Security for Multi-Tenant SaaS in PostgreSQL — Aman Kumar Singh
Triggers and Stored Procedures in PostgreSQL — Aman Kumar Singh
Materialized Views and Refresh Strategies in PostgreSQL — Aman Kumar Singh
Views in PostgreSQL: When They Help and When They Hurt — Aman Kumar Singh
Full-Text Search in PostgreSQL — Aman Kumar Singh
Arrays, Enums, and Composite Types in PostgreSQL — Aman Kumar Singh
Indexing and Querying JSONB Efficiently in PostgreSQL — Aman Kumar Singh
Working with JSONB in PostgreSQL — Aman Kumar Singh
MVCC, Dead Tuples, and VACUUM in PostgreSQL — Aman Kumar Singh
SELECT FOR UPDATE and Row-Locking Patterns in PostgreSQL — Aman Kumar Singh
Optimistic vs Pessimistic Locking in PostgreSQL — Aman Kumar Singh
Understanding and Preventing Deadlocks in PostgreSQL — Aman Kumar Singh
Locks in PostgreSQL and How to Avoid Contention — Aman Kumar Singh
PostgreSQL Isolation Levels Explained — Aman Kumar Singh
Transactions and ACID in PostgreSQL — Aman Kumar Singh
Show all 68 articles
Index Maintenance, Bloat, and REINDEX in PostgreSQL — Aman Kumar Singh
Finding and Fixing Slow Queries in PostgreSQL — Aman Kumar Singh
PostgreSQL Query Optimization Techniques — Aman Kumar Singh
Reading EXPLAIN and EXPLAIN ANALYZE in PostgreSQL — Aman Kumar Singh
Partial and Expression Indexes in PostgreSQL — Aman Kumar Singh
Composite and Covering Indexes in PostgreSQL — Aman Kumar Singh
Choosing the Right PostgreSQL Index Type — Aman Kumar Singh
How PostgreSQL Indexes Actually Work — Aman Kumar Singh
CTEs and Recursive Queries in PostgreSQL — Aman Kumar Singh
Window Functions in PostgreSQL — Aman Kumar Singh
Aggregations, GROUP BY, and HAVING in PostgreSQL — Aman Kumar Singh
SQL Joins in PostgreSQL, Explained Properly — Aman Kumar Singh
Constraints: Your Last Line of Data Integrity — Aman Kumar Singh
Primary Keys in PostgreSQL: UUID vs BIGINT — Aman Kumar Singh
Schema Design and Normalization in PostgreSQL — Aman Kumar Singh
Choosing the Right PostgreSQL Data Types — Aman Kumar Singh
Integration and E2E Testing — Aman Kumar Singh
The Outbox Pattern — Aman Kumar Singh
Pagination and Filtering — Aman Kumar Singh
Transactions and Data Integrity — Aman Kumar Singh
The Repository Pattern and Services — Aman Kumar Singh
Database Migrations in NestJS — Aman Kumar Singh
Connecting PostgreSQL with TypeORM — Aman Kumar Singh
Role and Permission Authorization — Aman Kumar Singh
The Production Readiness Checklist — Aman Kumar Singh
Performance Tuning Before Launch — Aman Kumar Singh
A Production Security Checklist — Aman Kumar Singh
Caching Strategies for a SaaS — Aman Kumar Singh
Disaster Recovery and Backups — Aman Kumar Singh
Scaling a SaaS Beyond One Server — Aman Kumar Singh
Feature Flags and Safe Rollouts — Aman Kumar Singh
Audit Logs You Can Trust — Aman Kumar Singh
Multi-Tenancy Architecture for SaaS — Aman Kumar Singh
Organizations, Teams, and Invitations — Aman Kumar Singh
Subscription Billing and Plans — Aman Kumar Singh
Product Analytics and Event Tracking — Aman Kumar Singh
Designing the SaaS Dashboard — Aman Kumar Singh
Adding Full-Text Search — Aman Kumar Singh
Building a Notification System — Aman Kumar Singh
Organization and Multi-Tenant Authentication — Aman Kumar Singh
Role-Based Access Control (RBAC) in a SaaS — Aman Kumar Singh
Choosing Prisma or TypeORM for Your NestJS API — Aman Kumar Singh
Setting Up PostgreSQL the Right Way — Aman Kumar Singh
Choosing the Right Tech Stack for Your SaaS (Without Overthinking It) — Aman Kumar Singh

Frequently asked questions

Do these PostgreSQL articles cover query performance?

Yes — indexing strategy, reading EXPLAIN / EXPLAIN ANALYZE, spotting sequential scans and N+1 patterns, and the schema decisions that make queries fast or slow before you ever write them.

Related topics

DatabasesRedisNestJS