All skills
Databases & Realtime
PostgreSQL
Latestv18.4Updated May 11, 2026
Overview
PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Windows, Linux, macOS, FreeBSD, and OpenBSD, and handles a range of workloads from single machines to data warehouses, data lakes, or web services with many concurrent users.
Read moreHow it works
sql
SELECT name, installs
FROM apps
WHERE rating >= 4.5
ORDER BY installs DESC;The flow
Step by step, from source to running.
- 1Client sends SQL over the wire
- 2Planner builds a query plan
- 3MVCC executor reads/writes rows
- 4Result set streamed back