---
title: "This Week's PostgreSQL News (#30)"
publication: "Postgres Weekly"
issue: 30
published_at: "2013-10-02"
canonical_url: "https://postgresweekly.com/issues/30"
---

Postgres Weekly Issue 30 - October 2, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/30)**Postgres Weekly****Issue 30**
October 2, 2013Featured[Exploring Query Locks in Postgres](http://big-elephants.com/2013-09/exploring-query-locks-in-postgres/?utm_source=postgresweekly&utm_medium=email)Ever been confused on how MVCC or locks work in Postgres? This is a great deep dive into how it all works and how you can take advantage of the functions to investigate your database further._Manuel Kniep_[Announcing PostgreSQL Studio 1.0](http://www.postgresql.org/about/news/1485/?utm_source=postgresweekly&utm_medium=email)An open-source, web-based GUI for PostgreSQL. It allows users to manage and query their database from a browser. Version 1.0 of PostgreSQL Studio is distributed under the PostgreSQL License._PostgreSQL Blog_From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)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._[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)The rest[From PG Open 2013: The Postgres Optimizer](http://hdombrovskaya.wordpress.com/2013/09/29/from-the-pg-open-2013-postgres-optimizer/?utm_source=postgresweekly&utm_medium=email)The Postgres Optimizer is a both elegant and mysterious part of PostgreSQL. Robert Haas gave a talk on this at Postgres Open, you can grab slides [here](https://sites.google.com/site/robertmhaas/presentations/Query%20Planning%20Gone%20Wrong.odp?attredirects=0&d=1) or check out this write-up on his talk.[Extra JSON Functions Needed](http://adpgtech.blogspot.com/2013/10/extra-functions-needed.html?utm_source=postgresweekly&utm_medium=email)The JSON functions available in Postgres 9.3 make the JSON datatype as useful as ever. With that said there’s always room for improvement, here’s a call for input from the creator for what additional functions that would make it even better.[The Power of Enums](http://www.openscg.com/2013/09/the-power-of-enums/?utm_source=postgresweekly&utm_medium=email)Enums while common at other times in languages aren’t an overly used feature in databases. Yet they can be incredibly powerful as demonstrated here.[Relatabase - Using Postgres Arrays with Rails 4](http://blog.relatabase.com/rails-postgres-arrays?utm_source=postgresweekly&utm_medium=email)Few applications don’t take advantage of arrays, Postgres has had support for arrays for years as well. Now you can work with them natively from Ruby on Rails.[And what about pg_cron with background workers?](http://michael.otacoo.com/postgresql-2/and-what-about-pg_cron-with-background-workers-2/?utm_source=postgresweekly&utm_medium=email)Background workers in PostgreSQL 9.3 make managing background jobs as easy as ever directly within Postgres. Here’s a dive into the concept of cron within Postgres and how it may look.Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)