What is PostgreSQL®?

PostgreSQL is a flexible open-source object relational database management system that can handle various use cases, from single machines to data warehouses to web services with many concurrent users. It uses and extends SQL (hence the name) and is broadly extensible to a range of use cases beyond mere transactional data. PostgreSQL supports transactions with ACID properties, meaning they must support atomicity, consistency, isolation, and durability. The database management system also offers features such as automatically updatable views, materialized views, triggers, foreign keys, stored procedures, pub/sub logical replication, change data capture, text search, recursive queries, json language support, concurrency, reliability, disaster recovery, security, and extensibility. Aiven for PostgreSQL is a managed and hosted solution that supports various extensions and integrates with other tools like Apache Kafka, OpenSearch, Redis, InfluxDB, and Grafana.