by admin ·
The new version of the DBMS PostgreSQL – 9.2.
The main changes in this version:
- «Index Only Scans» – the ability to choose the data directly from the index if the index they are. Prior to that database to use the index for searching the data itself is always chosen from the data pages. This feature only works if the page with the desired data has not changed since the last VACUUM.
- Cascading replication – standby server now also can send a transaction log to other sites
- JSON data type support for unstructured documents
- Added data types for a range of values