Skip to content

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.

  1. Part 1
    Choosing the Right PostgreSQL Data Types — Aman Kumar Singh
  2. Part 2
    Schema Design and Normalization in PostgreSQL — Aman Kumar Singh
  3. Part 3
    Primary Keys in PostgreSQL: UUID vs BIGINT — Aman Kumar Singh
  4. Part 4
    Constraints: Your Last Line of Data Integrity — Aman Kumar Singh
  5. Part 5
    SQL Joins in PostgreSQL, Explained Properly — Aman Kumar Singh
  6. Part 6
    Aggregations, GROUP BY, and HAVING in PostgreSQL — Aman Kumar Singh
  7. Part 7
    Window Functions in PostgreSQL — Aman Kumar Singh
  8. Part 8
    CTEs and Recursive Queries in PostgreSQL — Aman Kumar Singh
  9. Part 9
    How PostgreSQL Indexes Actually Work — Aman Kumar Singh
  10. Part 10
    Choosing the Right PostgreSQL Index Type — Aman Kumar Singh
  11. Part 11
    Composite and Covering Indexes in PostgreSQL — Aman Kumar Singh
  12. Part 12
    Partial and Expression Indexes in PostgreSQL — Aman Kumar Singh
  13. Part 13
    Reading EXPLAIN and EXPLAIN ANALYZE in PostgreSQL — Aman Kumar Singh
  14. Part 14
    PostgreSQL Query Optimization Techniques — Aman Kumar Singh
  15. Part 15
    Finding and Fixing Slow Queries in PostgreSQL — Aman Kumar Singh
  16. Part 16
    Index Maintenance, Bloat, and REINDEX in PostgreSQL — Aman Kumar Singh
  17. Part 17
    Transactions and ACID in PostgreSQL — Aman Kumar Singh
  18. Part 18
    PostgreSQL Isolation Levels Explained — Aman Kumar Singh
  19. Part 19
    Locks in PostgreSQL and How to Avoid Contention — Aman Kumar Singh
  20. Part 20
    Understanding and Preventing Deadlocks in PostgreSQL — Aman Kumar Singh
  21. Part 21
    Optimistic vs Pessimistic Locking in PostgreSQL — Aman Kumar Singh
  22. Part 22
    SELECT FOR UPDATE and Row-Locking Patterns in PostgreSQL — Aman Kumar Singh
  23. Part 23
    MVCC, Dead Tuples, and VACUUM in PostgreSQL — Aman Kumar Singh
  24. Part 24
    Working with JSONB in PostgreSQL — Aman Kumar Singh
  25. Part 25
    Indexing and Querying JSONB Efficiently in PostgreSQL — Aman Kumar Singh
  26. Part 26
    Arrays, Enums, and Composite Types in PostgreSQL — Aman Kumar Singh
  27. Part 27
    Full-Text Search in PostgreSQL — Aman Kumar Singh
  28. Part 28
    Views in PostgreSQL: When They Help and When They Hurt — Aman Kumar Singh
  29. Part 29
    Materialized Views and Refresh Strategies in PostgreSQL — Aman Kumar Singh
  30. Part 30
    Triggers and Stored Procedures in PostgreSQL — Aman Kumar Singh
  31. Part 31
    Row-Level Security for Multi-Tenant SaaS in PostgreSQL — Aman Kumar Singh
  32. Part 32
    Table Partitioning in PostgreSQL — Aman Kumar Singh
  33. Part 33
    Connection Pooling with PgBouncer in PostgreSQL — Aman Kumar Singh
  34. Part 34
    Streaming Replication and Read Replicas in PostgreSQL — Aman Kumar Singh
  35. Part 35
    High Availability and Failover in PostgreSQL — Aman Kumar Singh
  36. Part 36
    Backups and Point-in-Time Recovery in PostgreSQL — Aman Kumar Singh
  37. Part 37
    Tuning Autovacuum for Production in PostgreSQL — Aman Kumar Singh
  38. Part 38
    Monitoring PostgreSQL in Production — Aman Kumar Singh
  39. Part 39
    Scaling PostgreSQL: Vertical, Read Replicas, and Sharding — Aman Kumar Singh
  40. Part 40
    The PostgreSQL Production Checklist — Aman Kumar Singh