Home
<- All roadmaps/View on roadmap.sh

PostgreSQL

PostgreSQL DBA

Step by step guide to becoming a modern PostgreSQL DB Administrator in @currentYear@

This page is a visitor-friendly snapshot of how William currently sees this area: what feels strong, what is still being refined, and where the evidence is still partial.

9

Done

1

Learning

0

Target

0

Skipped

170

Tracked

Status meanings

Done: enough evidence to present this area as a solid strength.

Learning: an area of active development with growing confidence.

Target: relevant and intentional, but still earlier in the journey.

Skipped: not a current priority relative to other areas.

How the estimates are formed

Profile and manual review: 1

Evidence from project experience: 2

Competency mapping alignment: 7

Quiz-backed updates: 0

These signals help estimate progress, but they are still best treated as directional rather than perfectly complete.

Areas currently being strengthened

Transactions

This is actively developing and would benefit from more practice, proof, or recent examples.

Introduction

Done
Project experienceEvidence: experience

PostgreSQL vs NoSQL Databases

Untracked

What are Relational Databases?

Untracked

RDBMS Benefits and Limitations

Untracked

PostgreSQL vs Other RDBMS

Untracked

Basic RDBMS Concepts

Untracked

Object Model

Untracked

Queries

Untracked

Data Types

Untracked

Rows

Untracked

Columns

Untracked

Tables

Untracked

Schemas

Untracked

Databases

Untracked

Relational Model

Untracked

Domains

Untracked

Attributes

Untracked

Tuples

Untracked

Relations

Untracked

Constraints

Untracked

NULL

Untracked

High Level Database Concepts

Untracked

ACID

Done
Competency mapping

MVCC

Untracked

Transactions

Updated 3/21/2026

Learning
Profile and manual reviewEvidence: experience

Write-ahead Log

Untracked

Query Processing

Untracked

Using Docker

Untracked

Package Managers

Untracked

Connect using `psql`

Untracked

Deployment in Cloud

Untracked

Using `systemd`

Untracked

Using `pg_ctl`

Untracked

Using `pg_ctlcluster`

Untracked

Installation and Setup

Done
Competency mapping

Learn SQL

Done
Project experienceEvidence: experience

For Schemas

Untracked

ForTables

Untracked

Data Types

Untracked

Querying Data

Untracked

Filtering Data

Untracked

Modifying Data

Untracked

Joining Tables

Untracked

Import / Export Using `COPY`

Untracked

Transactions

Done
Competency mapping

Subqueries

Untracked

Grouping

Untracked

CTE

Untracked

Lateral Join

Untracked

Set Operations

Untracked

Configuring

Done
Competency mapping

Reporting Logging & Statistics

Untracked

Resource Usage

Untracked

Write-ahead Log

Untracked

Vacuums

Done
Competency mapping

Replication

Done
Competency mapping

Query Planner

Done
Competency mapping

Checkpoints / Background Writer

Untracked

Adding Extra Extensions

Untracked

Security

Untracked

Authentication Models

Untracked

Roles

Untracked

SSL Settings

Untracked

Object Privileges

Untracked

Grant / Revoke

Untracked

Default Privileges

Untracked

Advanced Topics

Untracked

Row-Level Security

Untracked

SELinux

Untracked

pg_hba.conf

Untracked

Infrastructure Skills

Untracked

Using `pg_upgrade`

Untracked

Using Logical Replication

Untracked

Simple Stateful Setup

Untracked

Helm

Untracked

Operators

Untracked

PostgreSQL Anonymizer

Untracked

HAProxy

Untracked

Consul

Untracked

KeepAlived

Untracked

Etcd

Untracked

Prometheus

Untracked

Zabbix

Untracked

check_pgactivity

Untracked

temBoard

Untracked

check_pgbackrest

Untracked

barman

Untracked

WAL-G

Untracked

pgbackrest

Untracked

pg_probackup

Untracked

pg_dump

Untracked

pg_dumpall

Untracked

pg_restore

Untracked

pg_basebackup

Untracked

Backup Validation Procedures

Untracked

PgBouncer

Untracked

PgBouncer Alternatives

Untracked

Logical Replication

Untracked

Streaming Replication

Untracked

Patroni

Untracked

Patroni Alternatives

Untracked

Resource Usage / Provisioning / Capacity Planning

Untracked

Learn to Automate

Untracked

Shell Scripts

Untracked

Any Programming Language

Untracked

Ansible

Untracked

Salt

Untracked

Chef

Untracked

Puppet

Untracked

Practical Patterns / Antipatterns

Untracked

Migration Related Tools

Untracked

Bulk Loading / Processing Data

Untracked

Data Partitioning

Untracked

Sharding Patterns

Untracked

Normalization / Normal Forms

Untracked

Patterns / Antipatterns

Untracked

PgQ

Untracked

Processes & Memory Architecture

Untracked

Vacuum Processing

Untracked

Buffer Management

Untracked

Lock Management

Untracked

Physical Storage and File Layout

Untracked

System Catalog

Untracked

Per-User, Per-Database Setting

Untracked

Storage Parameters

Untracked

OLTP

Untracked

OLAP

Untracked

HTAP

Untracked

PL/pgSQL

Untracked

Procedures and Functions

Untracked

Triggers

Untracked

Recursive CTE

Untracked

Aggregate and Window functions

Untracked

top

Untracked

sysstat

Untracked

iotop

Untracked

gdb

Untracked

strace

Untracked

ebpf

Untracked

perf-tools

Untracked

Core Dumps

Untracked

pgBadger

Untracked

pgCluu

Untracked

awk

Untracked

grep

Untracked

sed

Untracked

pg_stat_activity

Untracked

pg_stat_statements

Untracked

pgcenter

Untracked

EXPLAIN

Untracked

Depesz

Untracked

PEV2

Untracked

Tensor

Untracked

explain.dalibo.com

Untracked

USE

Untracked

RED

Untracked

Golden Signals

Untracked

Schema Design Patterns / Anti-patterns

Untracked

SQL Query Patterns / Anti-patterns

Untracked

Indexes and their Usecases

Untracked

B-Tree

Untracked

GiST

Untracked

SP-GiST

Untracked

Hash

Untracked

GIN

Untracked

BRIN

Untracked

Get Involved in Development

Untracked

Mailing Lists

Untracked

Reviewing Patches

Untracked

Writing Patches

Untracked