PostgreSQL

Learn about performance tuning with PostgreSQL databases and why it's so important.

Lessons

Each lesson focuses on a single aspect of building the project, like modeling the data, building a GraphQL server in Elixir, or building a mobile client for it in Flutter.

PostgreSQL: General Configuration 1

Getting up and running with PostgreSQL.

PostgreSQL: General Configuration 2

Understanding pg_hba.conf, postgresql.conf, and how to use them to tune our systems.

PostgreSQL: Vacuum / Autovacuum

Eliminate the bloat in your database with vacuum and autovacuum.

PostgreSQL: Analyze

How to keep PostgreSQL updated on the status of our tables so it can run queries as efficiently as possible.

PostgreSQL: Explain

Understand what is going on under the hood of your queries.

PostgreSQL: Efficient Queries - Indexing

How to index your tables to make your queries perform far more efficiently.

Authors

The code in the applications was produced by:

./alex allen

Alex Allen

Alex is an independent developer who is obsessed with both performance and information security. When not writing code, Alex is either playing guitar or working in his garden.

Featured Lessons

Our content library is pretty great, here are a few lessons we think you might like.

What our Superusers are Saying!

Some other people were willing to publicly state that they like us!

Taylor Dolezal

Software Architect

Smooth Terminal has easily been one of the most helpful resources on my journey to better understand Elixir and the Phoenix web framework.

James Edward II

Developer

With any language there are so many details to learn. What functions are built-in? How should I structure my code? What tools are available for improving my workflow? It’s rare to find one source that can answer so many of these questions, but Smooth Terminal does this and more.

Rex Van Der Spuy

Game developer

Smooth Terminal is by far the best resource for learning Elm anywhere, and among the very best online learning platforms, period.