Postgres Weekly Issue 33
October 23, 2013
Progress on Implementing Parallelism in Postgres
Parallelism has been desired within Postgres for a few years now. Fortunately one of the core contributors has been plugging away on it recently. Get an update directly from him here on progress.
Robert Haas
Rapid Schema Development with PostgreSQL
Postgres has had some flexibility with hstore (a key value column type) for some time, now its JSON is richer, and with PLV8 it has full JavaScript support. Andrew Godwin recently highlighted all this and how you can move faster with Postgres in many cases at Allyourbaseconf.
Andrew Godwin
From our sponsor
Heroku Postgres - Fully managed Postgres on EC2
There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
The rest
PostgreSQL Autonomous Transactions
In addition to parallelism, autonomous transactions are one of those features missing within Postgres. Fortunately you can get that functionality without too much extra effort with PL/Proxy
Dimitri Fontaine
Using Custom Composite Types in PostgreSQL
Composite types can offer you a bit more power within Postgres and can often be quite easy to work with. Here’s a specific look at using them specifically within PL/pgsql.
Pavel Stehule
post_json: A Document Database by Combining Features of Ruby, ActiveRecord and PostgreSQL with PLV8
node-pg-query-stream: Query results from node-postgres as a readable (object) stream
Query results from node-postgres as a readable (object) stream
Brian C
E-Maj 1.1.0 released
If you need logging around various groups of tables for auditing and an ability to recover from them heres an extension to help with just that.
PostgreSQL news