Download PostgreSQL 9.6

Version 9.6 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 this open source database became closed source. Detailed information about the changes in version 9.6 can be this page are being found. The complete changelog is available herethese are in short the most important improvements:

Major enhancements in PostgreSQL 9.6 include:

• Parallel execution of sequential scans, joins and aggregates
• Avoid scanning pages unnecessarily during vacuum freeze operations
• Synchronous replication now allows multiple standby servers for increased reliability
• Full-text search can now search for phrases (multiple adjacent words)
• postgres_fdw now supports remote joins, sorts, UPDATEs, and DELETES
• Substantial performance improvements, especially in the area of ​​scalability on multi-CPU socket servers