PostgreSQL 9.3 Blog Posts

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

Arrays: array remove/array replace

• array_remove() and array_replace() functions (depesz, 2012-07-12)

COPY: COPY FREEZE

• Postgres 9.3 feature highlight: COPY FREEZE (Michael Paquier, 2013-01-22)

COPY: piping to and from external programs

• Add support for piping COPY to/from an external program. (depesz, 2013-02-28)

Foreign Data Wrappers: postgres_fdw

• postgres_fdw (Michael Paquier, 2013-02-22)
• postgres_fdw: a Test Drive (Leo Hsu / Regina Obe, 2013-02-22)

Foreign Data Wrappers: writeable foreign tables

• Postgres 9.3 feature highlight: writable foreign tables (Michael Paquier, 2013-03-14)
• Waiting for 9.3 – Support writable foreign tables (depesz, 2013-03-17)

Indexing improvements

• Support indexing of regular-expression searches in contrib/pg_trgm. (depesz, 2013-04-10)

JSON support

• JSON generation improvements (depesz, 2013-03-12)
• Add new JSON processing functions and parser API (depesz, 2013-03-30)
• Postgres 9.3 feature highlight: JSON data generation (Michael Paquier, 2013-04-04)
• JSON operators (Michael Paquier, 2013-04-11)
• JSON parsing functions (Michael Paquier, 2013-04-18)

Replication: allow streaming standby to follow timeline switch

• Allow a streaming replication standby to follow a timeline switch (depesz, 2012-12-22)
• Timeline switch of slave node without archives (Michael Paquier, 2012-12-25)

Server: Background Worker Processes:

• Background worker processes (depesz, 2012-12-07)
• Postgres 9.3 feature highlight: handling signals with custom bgworkers (Michael Paquier, 2013-03-28)
• Custom background workers (Michael Paquier, 2013-01-20)
• "Hello World" with custom bgworkers (Michael Paquier, 2013-02-12)

Server: log more information about login failures

• Report pg_hba line number and contents when users fail to log in (depesz, 2013-03-12)

Server: log object names seperately

• Provide database object names as separate fields in error messages. (depesz, 2012-03-07)

SQL: Lateral Subqueries

• Implement SQL standard lateral subqueries (depesz, 2012-08-19)
• PostgreSQL 9.3 Lateral Part 1: Use with HStore (Leo Hsu / Regina Obe. 2013-01-06)
• PostgreSQL 9.3 Lateral Part 2: The Lateral Left Join (Leo Hsu / Regina Obe, 2013-01-06)

Transactions: FOR KEY SHARE / FOR KEY UPDATE

• FOR KEY SHARE and FOR NO KEY UPDATE (Michael Paquier, 2013-01-29)

Triggers: Event Triggers

• Event triggers (depesz, 2012-07-29)

Utilities: pg_dump

• Add parallel pg_dump option (depesz, 2013-03-26, 2013-03-26)
• parallel pg_dump (Michael Paquier, 2013-04-25)

Utilities: pg_isready

• pg_isready (depesz, 2013-01-26)
• Server monitoring with pg_isready (Michael Paquier, 2013-02-03)

Utilities: pg_xlogdump

• pg_xlogdump (Michael Paquier, 2013-02-27)

Utilities: psql

• Create a psql command \gset to store query results into psql variables (depesz, 2012-02-03)
• Add \watch [SEC] command to psql. (depesz, 2012-04-07)
• \watch in psql (Michael Paquier, 2012-05-02)

Views: Automatically-Updatable Views

• Support automatically updateable views (depesz, 2012-12-11)
• Auto-updateable views (Michael Paquier, 2013-01-12)

Views: Materialised Views

• Add a materialized view relations (depesz, 2013-03-04)
• Materialized views (Michael Paquier, 2013-03-08)

Views: Recursive Views

• Add CREATE RECURSIVE VIEW syntax (depesz, 2013-03-04)