Types of Indexes in PostgreSQL

Checklist to tune PostgreSQL Query performance

Setup Streaming Replication in PostgreSQL

Understanding Streaming Replication in PostgreSQL

Maintenance (Vacuum, Analyze, Re-index) in PostgreSQL

Memory Parameters in PostgreSQL

Memory Components in PostgreSQL

Types of Join: Nested Loop, Merge and Hash Joins in SQL Server