The new PostgreSQL 9.3 brings expanded reliability, availability, and ability to integrate with other databases.
With this new release, you can
build applications by enjoying new reliability, availability, and ability to integrate with other
databases.
In addition this latest version 9.3 makes PostgreSQL's Foreign Data
Wrappers writable, enabling two-way data interchange between systems.
According to Postgresql today’s complex IT environments involve multiple
databases and semi-structured data sources, therefore PostgreSQL can help you
integrate them into a coherent stack.
As we can observe, this new release includes features to further improve
and extend
PostgreSQL's well-known reliability and availability. In this
dynamic, Connectikpeople has nabbed: - Data Page Checksums: help administrators quickly detect failing disks and bad hardware that corrupts data
- Fast Failover: enables sub-second switchoffs from master to replica, supporting "carrier-grade" availability
- Streaming-Only Remastering: ‘’easier, faster’’ reconfiguration of cascading replicas after failover
For application developers, administrators and architects, the new release
includes:
- Additional JSON constructor and extractor methods
- Automatically updatable VIEWs
- Parallel pg_dump to speed backups of large databases
- LATERAL JOINs
Connectikpeople may also recall that, PostgreSQL 9.3's User-Defined
Background Workers allow developers to write task managers, request handlers,
parallel processors, queuing tools and other helper applications to enable
PostgreSQL as a workload coordinator.