| Postgres Weekly |
Issue 36
November 20, 2013
|
|
| Amazon RDS for PostgreSQL |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
| Efficient Django QuerySet Use |
|
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 |
|
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 |
|
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 |
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.
|
|
 |
|
|
|