PostgreSQL 9.3

Major features

SQL changes

General:

  • LATERAL sub-select syntax added (commit 5ebaaa49)

Added:

Modified:

Backend changes

System catalogue changes

Tables

Added:

Modified:

Views

Added:

System functions

Added:

Configuration changes

Added:

Removed:

Replication changes

  • "fast" promotion added (commit fd4ced52)

Foreign data wrapper changes

Server utilities

Modified:

Core utilities

Added:

Modified:

psql changes

  • only warn when connecting to a newer server version (commit 5cad0245)

Contrib modules

Added:

Modified:

  • dblink
    • modified to use foreign data wrapper functionality (commit 8255566f)
  • pgrowlocks
    • following changes made to pgrowlocks() result columns (commit 0ac5ad51):
      • column lock_type removed
      • column mode added
  • pgstattuple
    • function pgstatginindex() added (commit 357cbaae)
  • pg_upgrade
    • --jobs option added to enable parallel schema dump/restore of databases, as well as parallel copy/link of data files (commit 6f1b9e4e and commit a89c46f9)
    • improvements to status display (commit 6dd95845)
    • performance improvement for databases with large numbers of tables (commit 29add0de)
    • properly detect the location of non-default socket directories (commit f763b771)
  • sepgsql
    • enforce db_procedure:{execute} permission (commit f8a54e93)
    • enforce db_schema:search permission (commit e965e634)
    • allow sepgsql labels to depend on object name (commit 0f05840b)
    • support for object_access_hook's new OAT_POST_ALTER type (commit 1cea9bbb)