Postgres learning resources and community

The nine reading-and-community sections of awesome-postgres — Tutorials, Blogs, Documentation, Newsletters, Podcasts, Videos, Community, Roadmaps and External Lists — roughly fifty-five entries, as catalogued on 2026-08-20, at the catalog's word (T3). None has been read; this page records the roster so the catalog is fully accounted for, and flags the handful that are candidate sources for future ingests rather than merely links.

Documentation and reference

Wiki (official user documentation and how-tos) · pgPedia (encyclopedia of PostgreSQL topics) · Operations cheat sheet (official Wiki operations reference) · SQL Syntax Cheat Sheet · create_pg_super_document (AI-generated codebase documentation) · Wikipedia admin tools list · PostgreSQL Wiki GUI tools · PostgreSQL Wiki Foreign Data Wrappers

That last one is a gap-filler: foreign data wrappers are how Postgres reads other systems, they are the mechanism under cstore_fdw in the Extensions section, and this corpus has no page on them.

Tutorials and practice

Postgres Guide · PostgreSQL Exercises (learn by doing) · PG Casts (weekly screencasts by Hashrocket) · tutorialspoint PostgreSQL · PostgreSQL Primer for Busy People · PostgreSQL Roadmap (step-wise DBA guide) · pg-utils (DBA tools by Data Egret) · postgresDBSamples · pagila (the sample database) · Backup and recover using wal-e (superseded — see postgres-backup-tooling, where the catalog itself marks wal-e obsolete)

Blogs

Planet PostgreSQL (the aggregator) · Bruce Momjian · Robert Haas · Michael Paquier · Andrew Dunstan · Craig Kerstiens · select * from depesz; (Hubert Lubaczewski) · Database Soup (Josh Berkus) · Digoal (Chinese-language) · Percona's PostgreSQL posts · Metis Blog · Pigsty blog · BigData Boutique blog

Several of these are written by core committers, which makes them a different tier from a vendor blog — the standing caution this spoke applies to planetscale-768-servers does not apply the same way to a committer explaining a feature they wrote. depesz in particular is the long-running source for what changed in each release; Momjian and Haas for design rationale.

Newsletters, podcasts, video

Postgres Weekly · pgMustard newsletter · pgsql-hackers Weekly Digest (mailing-list digest with summaries) · PostgresFM (weekly topic discussions) · Scaling Postgres (weekly roundups, also a video series) · Path to Citus Con (monthly interviews) · PostgresTV · Postgres Conference · Citus Data and EnterpriseDB channels

The pgsql-hackers Weekly Digest is the highest-value entry in this whole page for the spoke's purposes: pgsql-hackers is where the engine's design is actually argued, and a summarised digest is a readable route into primary design discussion. It is the obvious source for the internals questions write-ahead-logging and postgresql-planner-statistics both end on.

Community

Official mailing lists · r/PostgreSQL (12,000+ users) · Slack (20k+ members) · Discord (6k+) · Telegram (Russian, Portuguese, Indonesian, English groups) · #postgresql on Freenode (1,000+ users — Freenode's own status makes this the clearest dead entry in the catalog, listed without comment)

awesome-postgres · postgresql · write-ahead-logging · postgresql-planner-statistics · postgres-backup-tooling · operational-databases