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

Postgres Weekly Issue 36 - November 20, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/36)**Postgres Weekly****Issue 36**
November 20, 2013[Amazon RDS for PostgreSQL](http://aws.amazon.com/rds/postgresql/?utm_source=postgresweekly&utm_medium=email)If you’re on Amazon and have longed for Postgres support… well its finally here. Amazon now has Postgres support in public beta, and I’m confident will be improving it over time._Amazon_[A First Look at PostgreSQL RDS on Amazon](http://www.databasesoup.com/2013/11/first-look-at-postgresql-rds-on-amazon.html?utm_source=postgresweekly&utm_medium=email)Just a day after the initial launch of Postgres on RDS one of the key Postgres community members took a look under the covers of it. Here’s a great write up of what its good for and where you may still want other options._Database Soup_[effective_cache_size: Better Set It Right](http://www.cybertec.at/effective_cache_size-better-set-it-right/?utm_source=postgresweekly&utm_medium=email)Postgres has a vast array of configuration settings. Many of them can be extremely safe even if you misconfigure, but others such as effective_cache_size can have a broad impact on the performance of your database._Cybertec Schönig_[Introducing Heroku Postgres 2.0](https://postgres.heroku.com/blog/past/2013/11/11/heroku_postgres_20/?utm_source=postgresweekly&utm_medium=email)If running and managing your own Postgres isn’t your cup of tea, for sometime there’s been Heroku Postgres. With a new version it's now even more feature-rich including rollback, HA, and a new level of operational expertise built right in._Heroku_[Everyday Postgres: INSERT with SELECT](http://www.chesnok.com/daily/2013/11/19/everyday-postgres-insert-with-select/?utm_source=postgresweekly&utm_medium=email)If you’re inserting a lot of repetitive data via a bunch of insert statements theres a better way to do this as Selena points out in this practical but helpful tip._Selena Deckelmann_[The best Postgres feature you're not using – CTEs aka WITH clauses](http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/?utm_source=postgresweekly&utm_medium=email)CTEs or Common Table Expressions are a great way to make your SQL more readable and able to be reasoned about. If you’re not familiar with them make sure to give this one a look to see how and where you can start using them._Craig Kerstiens_[Efficient Django QuerySet Use](http://www.slideshare.net/Counsyl/efficient-djangoquery-setuse?utm_source=postgresweekly&utm_medium=email)If you use Django’s ORM then there may be some potholes that introduce some less than ideal performance characteristics. Here’s a great set of slides from a recent talk on working better with your database with Django._Jayson Falkner_[Sequel and Postgres Range Types](http://datachomp.com/archives/sequel-and-postgres-range-types/?utm_source=postgresweekly&utm_medium=email)Range types are one of those awesome features that for certain use cases makes total sense. If you’re using them in an ORM then you may be missing out, fear not though because here’s a guide for taking advantage of them with the Ruby Sequel ORM._Datachomp_[Writable CTEs in Postgres](http://datachomp.com/archives/writable-ctes-in-postgres/?utm_source=postgresweekly&utm_medium=email)If you’re brand new to CTEs make sure to check out the other post available this week. If you’re more familiar you still may have not used them for writing data as well, which can be extremely handy._Datachomp_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|*)