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)