Relational database
The world's most advanced open-source relational database.
An extensible, standards-compliant RDBMS known for MVCC, rich data types (JSONB, arrays, ranges), powerful indexing (B-tree, GIN, GiST, BRIN) and a huge extension ecosystem.
PostgreSQLAdvancedA one-line migration can freeze every query on a table. lock_timeout, CREATE INDEX CONCURRENTLY, NOT VALID constraints and expand-and-contract keep schema changes online.
#indexing#locking#migrations
MVCC means Postgres doesn't store a row count. Make exact counts cheaper, get instant estimates from the planner, and keep exact counters when you really need them.
#internals#mvcc#performance
PostgreSQLAdvancedEvery UPDATE in PostgreSQL leaves a dead row behind. Here's how MVCC works under the hood, what VACUUM cleans up, and how to keep autovacuum ahead of your workload.
#concurrency#internals#maintenance
PostgreSQLIntermediateLearn to read PostgreSQL query plans node by node — estimates vs. actuals, loops, buffers — and turn them into index and query fixes.
#execution-plans#indexing#performance
PostgreSQLBeginnerInstall a current PostgreSQL release on Windows, Debian or Ubuntu, RHEL-family Linux or Docker, make the first connection and fix the usual post-install errors.
#installation
PostgreSQLBeginnerUnderstand PostgreSQL table, row and advisory locks, see which session is blocking which, handle deadlocks and run schema changes without stalling the application.
