PostgreSQL — Resources¶
[!WARNING] Verified resources only. Every entry in this file must be something you have personally confirmed exists, is accessible, and is genuinely useful. Do not add resources based on hearsay, AI suggestions, or titles that "sound right." A short list of excellent resources beats a long list of unverified ones.
Official Documentation¶
- PostgreSQL Documentation — The primary reference. Comprehensive, accurate, and searchable. Start here when you have a specific question about any feature.
- PostgreSQL Release Notes — Track changes across major versions; understand what changed and when.
- PostgreSQL SQL Commands Reference — The canonical reference for every SQL statement PostgreSQL supports.
Books¶
| Title | Author | Level | Format | Notes |
|---|---|---|---|---|
| The Art of PostgreSQL | Dimitri Fontaine | Intermediate–Advanced | Print/eBook | Covers real-world SQL patterns; excellent on CTEs, window functions, and application-database integration. Verify current edition URL at theartofpostgresql.com |
| PostgreSQL: Up and Running (3rd ed.) | Regina Obe & Leo Hsu | Beginner–Intermediate | Print/eBook (O'Reilly) | Good survey of the full feature set; strong chapters on PostGIS and extensions |
| PostgreSQL High Performance Cookbook | Chitij Chauhan & Dhruv Mehta | Advanced | Print/eBook (Packt) | Verify current edition — covers tuning, replication, and partitioning in depth |
| [Verify: "The Internals of PostgreSQL" — confirm URL] | Hironobu Suzuki | Expert | Free online | Deep dive into Postgres internals: heap files, WAL, MVCC, and the executor |
Online Courses¶
| Course | Platform | Level | Free? | Notes |
|---|---|---|---|---|
| PostgreSQL Tutorial | postgresqltutorial.com | Beginner | Yes | Well-structured series covering basics through intermediate; good for following along with Module 01–03 |
| Learn PostgreSQL | learnpostgresql.com | Beginner | Verify | Covers installation through intermediate queries |
| Practical SQL | No Starch Press | Beginner–Intermediate | No (book) | Anthony DeBarros; good for data analysts learning SQL via Postgres |
Video Resources¶
| Title / Channel | URL | Type | Level | Notes |
|---|---|---|---|---|
| Hussein Nasser — PostgreSQL internals | YouTube | Series | Intermediate–Advanced | Backend engineering channel; multiple deep-dive Postgres videos on WAL, MVCC, indexing |
| CMU 15-445 Database Systems Lectures | YouTube | Full course lectures | Advanced | Andy Pavlo's Carnegie Mellon course; covers relational internals that underpin Postgres |
Blogs & Articles¶
- PostgreSQL Wiki — Community-maintained knowledge base; excellent "Don't do this" page listing common anti-patterns
- GitLab Database Team Blog — Real-world production Postgres operations at scale; covers migration patterns, index strategies, and bloat management
- Cybertec PostgreSQL Blog — Technical articles by Postgres core contributors; reliable and accurate
- depesz.com — Hubert Lubaczewski's blog; famous for EXPLAIN ANALYZE visualizer and deep query plan analysis
Papers & Research¶
| Title | Authors | Year | Link | Why It Matters |
|---|---|---|---|---|
| A Relational Model of Data for Large Shared Data Banks | E. F. Codd | 1970 | ACM | The foundational paper that defined the relational model; understanding it explains every design decision in PostgreSQL |
| The Design of POSTGRES | M. Stonebraker, L. Rowe | 1986 | ACM | Describes the original POSTGRES design goals and the extensible type system |
| A Critique of ANSI SQL Isolation Levels | H. Berenson et al. | 1995 | ACM | The paper that defines the modern understanding of isolation levels; directly relevant to Module 05 |
Tools & Libraries¶
| Tool / Library | Language | Purpose | Link |
|---|---|---|---|
| pgAdmin 4 | Web/Desktop | GUI administration and query editor | pgadmin.org |
| psql | CLI | Primary interactive terminal for PostgreSQL | Built into every Postgres installation |
| pg_dump / pg_restore | CLI | Backup and restore | Built into every Postgres installation |
| EXPLAIN Visualizer (explain.depesz.com) | Web | Visualize and annotate EXPLAIN ANALYZE output | explain.depesz.com |
| pgBench | CLI | Built-in benchmarking tool | Built into every Postgres installation |
| pg_activity | Python/CLI | Real-time top-like monitoring for Postgres | github.com/dalibo/pg_activity |
| asyncpg | Python | High-performance async PostgreSQL driver | github.com/MagicStack/asyncpg |
| psycopg2 / psycopg3 | Python | Standard sync and async Postgres adapter | psycopg.org |
Communities¶
| Community | Platform | Focus | Link |
|---|---|---|---|
| r/PostgreSQL | General discussion | reddit.com/r/PostgreSQL | |
| PostgreSQL Mailing Lists | Developer and user discussion | postgresql.org/list/ | |
| Stack Overflow | Stack Overflow | Technical Q&A | Tag: postgresql |
| PostgreSQL IRC / Slack | IRC / Slack | Real-time community | See postgresql.org/community/ |
Cheat Sheets & Quick References¶
- PostgreSQL cheat sheet (postgresqltutorial.com) — Compact reference covering common SQL commands
- psql commands cheat sheet — Official reference for all psql backslash meta-commands
See also the local CHEATSHEET.md which you'll build yourself as you study.
My Recommendations¶
Fill in as you progress — what actually helped you most?
Best for Absolute Beginners¶
To be filled in
Best for Building Mental Models¶
To be filled in
Best for Practical / Hands-On Learning¶
To be filled in
Best Deep Reference¶
To be filled in
Resources to Evaluate¶
Drop links here when you find something but haven't verified it yet.
- Use the Postgres EXPLAIN tool at explain.dalibo.com — needs verification vs. explain.depesz.com
- "PostgreSQL 14 Internals" book by Egor Rogov — needs edition/URL verification before recommending