Software Update: PostgreSQL 9.3
Version 9.3 of PostgreSQL has been released. This popular ‘open source relational database management system’ runs on a large number of operating systems and can therefore be used in various environments. It is a derivative of Ingres, after its lead developer started his own business and that open source database became closed source. More information about this release can be found in the release notes Here are the main improvements:
Major enhancements in PostgreSQL 9.3 include:
- Add materialized views
- make simple views auto-updateable
- Add many features for the JSON data type, including operators and functions to extract elements from JSON values
- Implement SQL standard LATERAL option for FROM-clause subqueries and function calls
- allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables
- Add a Postgres foreign data wrapper to allow access to other Postgres servers
- Add support for event triggers
- Add optional ability to checksum data pages and report corruption
- Prevent non-key-field row updates from blocking foreign key checks
- Greatly reduce System V shared memory requirements
Version number | 9.3 |
Release status | Final |
Operating systems | Windows 7, Linux, BSD, Windows XP, macOS, Solaris, Windows Server 2003, Windows Vista, Windows Server 2008, Windows Server 2012, Windows 8 |
Website | PostgreSQL |
Download | http://www.postgresql.org/download |
License type | Conditions (GNU/BSD/etc.) |