Related Roadmaps Find the detailed version of this roadmap
along with other similar roadmaps
MongoDB Roadmap
Backend Roadmap
roadmap.sh
PostgreSQL
Queries
What are Relational Databases?
Data Types
RDBMS Benefits and Limitations
Rows Columns Introduction
PostgreSQL vs NoSQL Databases
Tables Schemas
PostgreSQL vs Other RDBMS
Databases
Object Model Basic RDBMS Concepts High Level Database Concepts
ACID MVCC Transactions
Relational Model
Write-ahead Log
Domains Attributes
Query Processing
Tuples Relations
Constraints NULL Installation and Setup
DDL Queries DML Queries
For Schemas Querying Data
Using Docker Managing Postgres
ForTables Filtering Data
Package Managers Using `systemd`
Learn SQL Data Types Modifying Data
Connect using `psql` Using `pg_ctl`
Joining Tables
Deployment in Cloud Using `pg_ctlcluster`
Import / Export Using `COPY`
Reporting Logging & Statistics Configuring
Advanced Topics
Adding Extra Extensions
Transactions CTE
Following postgres.conf configuration
Subqueries Lateral Join
Resource Usage Default Priviliges
Grouping Set Operations
Write-ahead Log Grant / Revoke
Vacuums Replication Object Priviliges
Query Planner
Authentication Models Advanced Topics
Checkpoints / Background Writer
Security Roles pg_hba.conf Row-Level Security
SSL Settings SELinux
Infrastructure Skills
Anonymization Backup & Recovery Tools
PostgreSQL Anonymizer
3rd Party Builtin Tools
Upgrade Procedures
barman WAL-G pg_dump pg_dumpall
Using `pg_upgrade`
pgbackrest pg_restore
Learn to Automate
Using Logical Replication
pg_probackup pg_basebackup
Shell Scripts
Cluster Management
Backup Validation Procedures
Any Programming Language Patroni
Replication Connection Pooling
DevOps Roadmap Patroni Alternatives
Logical Replication PgBouncer
Configuration Management
Kubernetes Deployment
Ansible Salt Streaming Replication PgBouncer Alternatives
Simple Stateful Setup
Puppet Chef Monitoring
Helm Operators
Prometheus Zabbix temBoard
Load Balancing / Discovery
check_pgactivity check_pgbackrest
HAProxy Consul
KeepAlived Etcd Resource Usage / Provisioning / Capacity Planning
Application Skills Migrations Data and Processing
Practical Patterns / Antipatterns Bulk Loading / Processing Data
Migration Related Tools Data Partitioning
Advanced Topics
Queues Sharding Patterns
Patterns / Antipatterns PgQ Normalization / Normal Forms
Low Level Internals
Processes & Memory Architecture
Fine-grained Tuning Advanced SQL
Vacuum Processing
Per-User, Per-Database Setting PL/pgSQL
Buffer Management
Storage Parameters Procedures and Functions
Lock Management Workload-Dependant Tuning Triggers Recursive CTE
Physical Storage and File Layout OLTP OLAP HTAP
Aggregate and Window functions
System Catalog
Troubleshooting Techniques
Posgres System Views Query Analysis Profiling Tools Operating System Tools
pg_stat_activity EXPLAIN Depesz perf-tools top sysstat iotop
pg_stat_statements PEV2 Tenser gdb strace Log Analysis
Techniques explain.dalibo.com Core Dumps pgCluu
USE RED Posgres Tools ebpf pgBadger
Golden Signals pgcenter awk grep sed
SQL Query Patterns / Anti-patterns SQL Optimization Techniques
Schema Design Patterns / Anti-patterns
B-Tree BRIN
Indexes and their Usecases GiST Hash
SP-GiST GIN
Mailing Lists
Reviewing Patches Get Involved in Development
Writing Patches
Visit the following relevant roadmaps
MongoDB Backend
