What's new in PostgreSQL 9.3

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Created page with "= PostgreSQL 9.3 Features = This page contains additional information about PostgreSQL Version 9.3's features, including descriptions, testing information, links to blogs, and u…")
 
(List of Significant Features)
Line 11: Line 11:
 
* LATERAL JOINs
 
* LATERAL JOINs
 
* Additional JSON constructor and extractor functions
 
* Additional JSON constructor and extractor functions
 +
* Switch to Posix shared memory and mmap().
 
* Indexed regular expression search
 
* Indexed regular expression search
 
* Disk page checksums to detect filesystem failures
 
* Disk page checksums to detect filesystem failures
Line 23: Line 24:
 
* Recursive view declaration
 
* Recursive view declaration
  
==
+
== Writeable Foreign Tables ==
 +
 
 +
Foreign data sources can now be written to, as well as read, provided that the FDW driver supports it.  As of this writing, the Redis driver supports this, but other drivers are expected to add this enhancement before 9.3 final.
 +
 
 +
== pgsql_fdw driver for federation of PostgreSQL databases ==
 +
 
 +
New PostgreSQL-to-PostgreSQL foreign data wrapper, which allows writes and "pushdown" of some query clauses to the external server.
 +
 
 +
== Simple views are now auto-updatable ==
 +
 
 +
Simple views that reference some or all columns from a single base table are now updatable by default. More complex views can be made updatable using INSTEAD OF triggers or INSTEAD rules.
 +
 
 +
== Materialized Views ==
 +
 
 +
Unlike ordinary views, where the base tables are read on every access, materialized views create physical tables at creation or refresh time. Access to the materialized view reads from these materialized physical tables. There is no facility for incrementally refreshing materialized views or auto-accessing them via base table access.

Revision as of 00:33, 28 April 2013

Contents

PostgreSQL 9.3 Features

This page contains additional information about PostgreSQL Version 9.3's features, including descriptions, testing information, links to blogs, and usage information.

List of Significant Features

  • Writeable Foreign Tables: write to external databases as well as read from them
  • pgsql_fdw driver for federation of PostgreSQL databases
  • Automatically updatable VIEWs
  • MATERIALIZED VIEW declaration
  • LATERAL JOINs
  • Additional JSON constructor and extractor functions
  • Switch to Posix shared memory and mmap().
  • Indexed regular expression search
  • Disk page checksums to detect filesystem failures
  • Streaming-only remastering of replicas
  • Performance and locking improvements for Foreign Key locks
  • Parallel pg_dump for faster backups
  • Directories for configuration files
  • pg_isready database connection checker
  • 64-bit Large Object API
  • COPY FREEZE for reduced IO bulk loading
  • User-defined background workers for automating database tasks
  • Recursive view declaration

Writeable Foreign Tables

Foreign data sources can now be written to, as well as read, provided that the FDW driver supports it. As of this writing, the Redis driver supports this, but other drivers are expected to add this enhancement before 9.3 final.

pgsql_fdw driver for federation of PostgreSQL databases

New PostgreSQL-to-PostgreSQL foreign data wrapper, which allows writes and "pushdown" of some query clauses to the external server.

Simple views are now auto-updatable

Simple views that reference some or all columns from a single base table are now updatable by default. More complex views can be made updatable using INSTEAD OF triggers or INSTEAD rules.

Materialized Views

Unlike ordinary views, where the base tables are read on every access, materialized views create physical tables at creation or refresh time. Access to the materialized view reads from these materialized physical tables. There is no facility for incrementally refreshing materialized views or auto-accessing them via base table access.

Personal tools