PostgreSQL 9.3 Blog Posts

From PostgreSQL wiki

Jump to: navigation, search

This page contains a list of blog posts explaining new features and improvements in the upcoming PostgreSQL 9.3 release.

Contents

Arrays: array remove/array replace

COPY: COPY FREEZE

COPY: piping to and from external programs

Foreign Data Wrappers: postgres_fdw

Foreign Data Wrappers: writeable foreign tables

Indexing improvements

JSON support

Replication: allow streaming standby to follow timeline switch

Server: Background Worker Processes:

Server: log more information about login failures

Server: log object names seperately

SQL: Lateral Subqueries

Transactions: FOR KEY SHARE / FOR KEY UPDATE

Triggers: Event Triggers

Utilities: pg_dump

Utilities: pg_isready

Utilities: pg_xlogdump

Utilities: psql

Views: Automatically-Updatable Views

Views: Materialised Views

Views: Recursive Views

Personal tools