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

Postgres Weekly Issue 23 - August 14, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/23)**Postgres Weekly****Issue 23**
August 14, 2013Featured[What's new in PostgreSQL 9.3](http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.3?utm_source=postgresweekly&utm_medium=email)Now that Postgres 9.3 has an official release date of September 9 you can start to get even more excited about the slew of new features. There's a great overview of them available on the PostgreSQL wiki.[Fancy SQL Monday: ON vs. NATURAL JOIN vs. USING](http://www.databasesoup.com/2013/08/fancy-sql-monday-on-vs-natural-join-vs.html?utm_source=postgresweekly&utm_medium=email)Theres a lot of options on how you do joins within Postgres, and even when performing the exact same inner join. Here's a bit of a both historical and informative look at the methods you can use today.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[The missing PostgreSQL documentation](http://www.craigkerstiens.com/2013/08/07/the-missing-postgresql-documentation/?utm_source=postgresweekly&utm_medium=email)An open call by myself for others to help contribute in improving the PostgreSQL documentation. As always if you have content you feel others would find useful suggest it to [@craigkerstiens](http://www.twitter.com/craigkerstiens) for inclusion in Postgres Weekly._Craig Kerstiens_[Migrating from MySQL to PostgreSQL](http://tapoueh.org/blog/2013/08/08-MySQL-to-PostgreSQL.html?utm_source=postgresweekly&utm_medium=email)In case you found your way onto Postgres Weekly instead of the MySQL list by accident, here's yet another guide for migration from MySQL to Postgres.[A Flask of full-text search in PostgreSQL](http://coffeecode.net/archives/270-A-Flask-of-full-text-search-in-PostgreSQL.html?utm_source=postgresweekly&utm_medium=email)From a talk at PyCon CA here's some slides, notes, code on taking advantage of PostgreSQL's full text search. In this case its integrated in a simple but elegant fashion with Flask.[Time in PostgreSQL: Outer joins](http://www.cybertec.at/time-in-postgresql-outer-joins/?utm_source=postgresweekly&utm_medium=email)As a follow up to working with [Time in Postgres](http://www.cybertec.at/time-in-postgresql-the-simple-way/) here's a deeper dive on using outer joins and specifically with time.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|*)