A curated collection of best learning resources on IT topics

All topics -> Databases -> Postgres

PostgreSQL (a.k.a. Postgres) is one of the most popular and advanced open-source databases out there. It's a relational database management system (RDBMS) that supports a large part of the SQL standard and offers many modern features.

All major cloud providers including AWS, Azure, Google Cloud, Heroku, and Digital Ocean offer Postgres database as a managed service.

Links: www.postgresql.org, wiki.postgresql.org, PostgreSQL (Wikipedia), PostgreSQL (Wikibooks).

Here's 4 amazing resources to learn Postgres:

  1. PostgreSQL Documentation (www.postgresql.org)
    free • resource • 2023

    Postgres has an excellent documentation. It's large but easy to navigate. Preface, Part I, and Part II introduce you to Postgres and SQL and should be read cover-to-cover. Part III Server Administration is worth reading through if you manage your own database server. Part V Server Programming and Part VII Internals are for advanced users to take the most out of Postgres. And there is Part VI Reference anytime you need to get info on SQL commands or command-line tools – take a look what's there.

  2. PostgreSQL Wiki (wiki.postgresql.org)
    free • resource • 2023

    The wiki complements the docs with FAQ, how-tos, tips and tricks, and useful links related to Postgres. It also serves as a collaboration area for Postgres contributors. Browse Category:Main to see what's there.

  3. PostgreSQL on Wikibooks (en.wikibooks.org)
    free • book • 2023

    The PostgreSQL Wikibook gives a compressed summary of Postgres' main features and concepts. It's a good introduction to Postgres for those who are already familiar with other databases.

  4. PostgreSQL 14 Internals (postgrespro.com)
    free • book • 2023

    Do you find it hard sometimes to remember transaction guarantees on different isolation levels, to understand which index type to use in a particular case, or to figure out why an SQL query takes so long to execute. You'll be able to answer such questions without ready-made recipes and quick-fix patches if you understand how Postgres works under the hood. This book presents this complicated topic in a very accessible way.