PostgreSQL 10.5 release: open source object-relational database system
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database; and it is also available for Microsoft Windows and Linux (supplied in most distributions).
PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability.
PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors. It is free and open-source, released under the terms of the PostgreSQL License, a permissive software license. _Wiki
- Fix failure to reset libpq‘s state fully between connection attempts (Tom Lane)
INSERT ... ON CONFLICT UPDATEthrough a view that isn’t just
SELECT * FROM ...(Dean Rasheed, Amit Langote)
- Ensure that updates to the
relminmxidvalues for “nailed” system catalogs are processed in a timely fashion (Andres Freund)
- Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint (Michael Paquier, Kyotaro Horiguchi, Pavan Deolasee, Álvaro Herrera)
- Avoid emitting a bogus WAL record when recycling an all-zero btree page (Amit Kapila)
- During WAL replay, guard against corrupted record lengths exceeding 1GB (Michael Paquier)