What's new in PostgreSQL 9.3

Major enhancements in PostgreSQL 9.3 include:

1.  Materialized views
2. Many features for the JSON data type, including operators and functions to extract elements from JSON values
3. Add a Postgres foreign data wrapper to allow access to other Postgres servers
4. Support for event triggers
5. Add optional ability to checksum data pages and report corruption
6. Make simple views auto-updatable
7. Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls
8. Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables
9. Prevent non-key-field row updates from blocking foreign key checks
10. Greatly reduce System V shared memory requirements

Comments