| Postgres Weekly |
Issue 81
November 12, 2014
|
|
| Discovering the Computer Science Behind Postgres Indexes |
|
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 |
|
CTEs are great to help you create more readable SQL, 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 |
|
| Online JavaScript Courses Beginning Dec 8, Feb 2 & Mar 23 |
|
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 Reactor Sponsored |
|
 |
| Assignment beats SELECT INTO |
|
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 |
|
| We need a webapp benchmark |
|
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 |
|
|
|
|