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

Postgres Weekly Issue 38 - December 4, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/38)**Postgres Weekly****Issue 38**
December 4, 2013[PGCon 2014: The PostgreSQL Conference](http://www.pgcon.org/2014/?utm_source=postgresweekly&utm_medium=email)PGCon is the world's largest Postgres conference, packed with core developers and end users. If there’s one conference to get to for Postgres, this is it. A call for proposals is still open so if you’re doing something interesting be sure to submit a talk._PGCon_[Everyday Postgres: Tuning a brand-new server (the 10-minute edition)](http://www.chesnok.com/daily/2013/11/13/everyday-postgres-tuning-a-brand-new-server-the-10-minute-edition/?utm_source=postgresweekly&utm_medium=email)After a fresh install, there are probably a few knobs you want to tweak on Postgres. If you’re new to doing this, it can be a bit overwhelming. Here’s a quick primer on tuning a brand new server to be more properly configured._Selenda Deckelmann_[What can you do with PostgreSQL and JSON?](http://clarkdave.net/2013/06/what-can-you-do-with-postgresql-and-json/?utm_source=postgresweekly&utm_medium=email)JSON came along in PostgreSQL 9.2, but got a lot of great improvements with more operators by 9.3. Here’s a great look at some of the functionality now available for using JSON in Postgres._Dave Clark_[Improving the Command-Line Postgres Experience](http://robots.thoughtbot.com/improving-the-command-line-postgres-experience/?utm_source=postgresweekly&utm_medium=email)A common Postgres question is “what’s the best editor for Postgres?” I’ve taken my shot at answering this previously [with a response of plain old psql](http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/). Here’s yet another post to help you extend it further to be even more powerful with it._Thoughtbot_[Getting Started With PGBouncer](http://datachomp.com/archives/getting-started-with-pgbouncer/?utm_source=postgresweekly&utm_medium=email)If you’re running at any sort of scale with Postgres using a connection pooler is an absolute must. Here’s a lightweight post on getting your feet wet with the probably most common connection pooler, PGBouncer._Rob Sullivan_[PostgreSQL 9.2 and 9.3 Now Available on Travis CI](http://about.travis-ci.org/blog/2013-11-29-postgresql-92-93-now-available/?utm_source=postgresweekly&utm_medium=email)Travis CI, a popular CI tool (particularly for open source projects) now has richer Postgres support with their support for 9.2 and 9.3. They’ve also upgraded their own Postgres install and you can [read more about that too.](http://about.travis-ci.org/blog/2013-12-2-a-long-overdue-database-upgrade-heroku-postgres/)_Travis CI_[Reintroducing Hstore for PostgreSQL](http://www.infoq.com/news/2013/11/Nested-Hstore?utm_source=postgresweekly&utm_medium=email)Even though JSON is now here and offers some great usability, hstore still has its place in the Postgres world offering better performance in many places. Here’s a high level overview of some of the updates that are likely coming to hstore, and with any luck a convergence of hstore and JSON._InfoQ_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)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|*)