---
title: "This Week's PostgreSQL News (#141)"
publication: "Postgres Weekly"
issue: 141
published_at: "2016-01-27"
canonical_url: "https://postgresweekly.com/issues/141"
---

Postgres Weekly 141   . 

[Read this on the Web](http://postgresweekly.com/issues/141) 

[Postgres Weekly](http://postgresweekly.com) Issue 141 — January 27, 2016     

[All You Need to Know About Sorting in Postgres](http://madusudanan.com/blog/all-you-need-to-know-about-sorting-in-postgres/?utm_source=postgresweekly&utm_medium=email)During queries, Postgres often sorts your data behind the scenes for optimization purposes. This primer should give you a better understanding of how this sorting works. Madusudanan [Postgres Query Plan Visualization](http://tatiyants.com/postgres-query-plan-visualization/?utm_source=postgresweekly&utm_medium=email)Understanding the query plan or EXPLAIN output can be tricky, even for an experienced Postgres user. This is one of the best tools I’ve seen yet to help better understand how a query is performing. Alex Tatiyants#tools [Spot over-locking](http://dtdg.co/1OhYXXg)Datadog collects lock metrics over time, and can alert on changes immediately. With 50+ Postgres-specific metrics, Datadog helps you spot and fix issues before they're problems. Datadog#sponsored[![\](https://copm.s3.amazonaws.com/2ba509eb.png)](http://dtdg.co/1OhYXXg) [Improve Your PostgreSQL Workflow with vim and dbext](http://jonathansacramento.com/posts/20160122-improve-postgresql-workflow-vim-dbext.html?utm_source=postgresweekly&utm_medium=email) Jonathan Sacramento [Postgres FDW, One Year Later](https://gorthx.wordpress.com/2016/01/20/postgres-fdw-one-year-later/?utm_source=postgresweekly&utm_medium=email)If you didn’t know, Postgres ships with one foreign data wrapper out of the box – the Postgres one. Here’s a great write-up after extensive use on getting it set up and hands on with it. the gabriellephant [Postgres Checksum Performance Impact](http://blog.endpoint.com/2015/12/postgres-checksum-performance-impact.html?utm_source=postgresweekly&utm_medium=email)Checksums, made available in Postgres 9.3, are incredibly valuable to ensure your database doesn’t silently corrupt. But, as with most things they’re not free. Take a look at what performance impact turning them on may have. Greg Sabino Mullane [cstore_fdw and 'Files are Hard'](https://pykello.github.io/databases/2015/12/15/cstore-fdw-files/?utm_source=postgresweekly&utm_medium=email)[Files are hard](http://danluu.com/file-consistency/) was a great article that lays out so many of the issues on files and filesystems. As a response to that he laid out many of the choices in the popular extension [cstore](https://www.citusdata.com/community/cstore-fdw) from [Citus Data](https://www.citusdata.com/), a great read if you want to look at the internals of one approach to an interesting extension. pykello.​github.​io#code [Scenic: Versioned Database Views for Rails](https://github.com/thoughtbot/scenic?utm_source=postgresweekly&utm_medium=email)Scenic makes it easier to work with database views within your Rails application– without having to drop down to raw SQL. thoughtbot, inc.​ #code [Heroku Data Infrastructure Engineer](https://www.heroku.com/careers/104?utm_source=postgresweekly&utm_medium=email)Join the Heroku Data team and learn about supporting and operating database systems at scale. Heroku#job [Postgres Skills are in demand.](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres)Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today! Indeed#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/141) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK
