ㄴㅋㄹㅇ🌅

Basics

Transaction and Locking

Transaction Modes

Indexes

Index types

Extensions

Advanced SQL

Log files and System Statistics

Start with

Database

Tables

Indexes

Background workers

Queries

Logs

Optimizing Queries

joins

EXPLAIN

Semantics of joins

Partitioning

Partitioning after 11

Memory

Parallelism

JIT

Stored Procedures

Security

Network

SSL

Database

Table

DEFAULTS

RLS — row level security

Debugging

Backups

SQL

WAL

Replication

Async replication — commits on slaves allowed to happen after commit on master

Sync replication — commit must be flushed to disk by at least one replica

Replication Slots

Logical replication

Extensions

Troubleshooting