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.

Popular Posts