Domain: PostgreSQL Query Writing and Optimization

PostgreSQL Query Writing and Optimization

This domain owns SQL shape and runtime behavior in PostgreSQL: query formulation, planner choices, statistics, EXPLAIN interpretation, MVCC-visible locking behavior, deadlocks, and the tuning workflow that turns slow SQL into predictable production SQL.

Query Surface and Planner Basics

01-postgresql-query-surface-and-planner-basics

Data Types and Null Semantics

02-postgresql-data-types-conversion-and-null-handling

Joins, Correlation, and Set Logic

03-postgresql-joins-subqueries-and-lateral

CTEs and Temporary Structures

04-postgresql-common-table-expressions-and-temporary-objects

Window Analytics

05-postgresql-window-functions

Aggregation and Numeric Analysis

06-postgresql-numeric-and-aggregate-functions

Text and Pattern Logic

07-postgresql-string-functions-and-pattern-matching

Temporal Logic

08-postgresql-date-and-time-functions

Semi-Structured Data

09-postgresql-json-and-semi-structured-data

Data Modification

10-postgresql-insert-update-delete-patterns

Upsert and Merge Logic

11-postgresql-merge-and-upsert

Predicate Shape and Indexability

12-postgresql-sargable-queries

Execution Plans and Plan Reading

13-postgresql-execution-plans

Wait Events and Session Triage

14-postgresql-wait-events-and-session-analysis

Session Metadata and Context

15-postgresql-system-functions-and-session-metadata

Blocking, MVCC, and Locking

16-postgresql-blocking-and-locking

Deadlocks and Prevention

17-postgresql-deadlock-detection-and-prevention

Race Conditions and Isolation

18-postgresql-race-conditions

Procedural SQL and Error Handling

19-postgresql-functions-dynamic-sql-and-error-handling

Plan Cache Regressions and Remediation

20-postgresql-plan-caching-regressions-and-remediation