---
title: "none"
publication: "Postgres Weekly"
issue: 81
published_at: "2014-11-12"
canonical_url: "https://postgresweekly.com/issues/81"
---

Postgres Weekly Issue 81 - November 12, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/81)**Postgres Weekly****Issue 81**
November 12, 2014[Discovering the Computer Science Behind Postgres Indexes](http://patshaughnessy.net/2014/11/11/discovering-the-computer-science-behind-postgres-indexes?utm_source=postgresweekly&utm_medium=email)Continuing with his series of looking under the covers of what happens when you execute a query in Postgres, Pat Shaughnessy digs into what indexes are and how they work in Postgres. An awesome read if you want to learn more about what happens when you SELECT._Pat Shaughnessy_[Using Writeable CTEs to Improve Performance](http://omniti.com/seeds/writable-ctes-improve-performance?utm_source=postgresweekly&utm_medium=email)CTEs are great to help you create more [readable SQL](http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/), they also provide an ability to have upsert like functionality for Postgres. But even more than that can offer certain performance improvements where you’re conducting more complex inserts._Brian Dunavant_[PgTune: A Configuration Calculator for Postgres](http://pgtune.leopard.in.ua/?utm_source=postgresweekly&utm_medium=email)Input parameters about the system you’re running Postgres on and PgTune will suggest settings that are better than the defaults._Alexey Vasiliev_[Online JavaScript Courses Beginning Dec 8, Feb 2 & Mar 23](http://www.hackreactor.com/remote-beta/?utm_source=coopermedia=nov12postgresweeklyexclusive=remotebeta?utm_source=postgresweekly&utm_medium=email)We’ve just recently announced two new Online Immersive Courses beginning February 2nd and March 23rd. With our December 8th online course filling up fast, apply to Hack Reactor today and secure your spot in one of our three Remote Beta classes!_Hack ReactorSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/23801/t.png)](http://www.hackreactor.com/remote-beta/?utm_source=coopermedia=nov12postgresweeklyexclusive=remotebeta?utm_source=postgresweekly&utm_medium=email)[Assignment beats SELECT INTO](http://adpgtech.blogspot.com/2014/11/assignment-beats-select-into.html?utm_source=postgresweekly&utm_medium=email)Grabbing values from one query and inserting them in another? Here’s a quick read on the performance difference of a few ways of doing this._Andrew Dunstan_[Pgpool-II Enables Horizontal Scalability in Postgres](http://blogs.enterprisedb.com/2014/11/04/pgpool-ii-enables-horizontal-scalability-in-postgres/?utm_source=postgresweekly&utm_medium=email)_EnterpriseDB_[We need a webapp benchmark](http://www.databasesoup.com/2014/11/we-need-webapp-benchmark.html?utm_source=postgresweekly&utm_medium=email)Today there’s several industry standard benchmarks for databases, the problem is they don’t represent what most web applications do. Here’s some thoughts and high level proposal for fixing such._Josh Berkus_[Amazon RDS for PostgreSQL Update - Read Replicas, 9.3.5 Support, Migration, Three New Extensions](https://aws.amazon.com/blogs/aws/rds-postgres-read-replicas/?utm_source=postgresweekly&utm_medium=email)As Postgres on RDS matures over time, it’s now receiving some of the updates you’d hope to see such as newer Postgres versions, read replicas, and some of the more powerful extensions._Amazon_[3-2-1 Backup of Postgres on AWS to S3 and Offsite Server](http://engineroom.trackmaven.com/blog/3-2-1-backup-of-postgres-on-aws-to-s3-and-offsite-server/?utm_source=postgresweekly&utm_medium=email)_Fred Battista_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|*)