POSTGRESQL is an open-source object-relational database system. It is not controlled by any corporation or other private entity. The source code is available free of charge. PostgreSQL supports transactions, subselects, triggers, views, foreign key referential integrity, and sophisticated locking.
New features in Postgres are:
- 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.
Parallel execution of sequential scans, joins and aggregates
PostgreSQL can devise query plans which can leverage multiple CPUs in order to answer queries faster. This feature is known as the parallel query. Mostly, queries that touch a large amount of data but return only a few rows to the user will get benefit by using Parallel Query. It can now execute a full table scan in multiple parallel processes, up to the limits set by the user.
Avoid scanning pages unnecessarily during vacuum freeze operations