---
title: "This Week's PostgreSQL News (#136)"
publication: "Postgres Weekly"
issue: 136
published_at: "2015-12-16"
canonical_url: "https://postgresweekly.com/issues/136"
---

Postgres Weekly 136   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 136 — December 16, 2015     

[PostgreSQL Performance with Different I/O Schedulers](http://blog.pgaddict.com/posts/postgresql-with-different-io-schedulers?utm_source=postgresweekly&utm_medium=email)Benchmarks and analysis of running Postgres along with different Linux IO schedulers. [Some background here.](http://blog.pgaddict.com/posts/postgresql-io-schedulers-cfq-noop-deadline) Tomas Vondra [One Dimensional Clustering in Postgres](https://www.periscopedata.com/blog/one-dimensional-clustering-in-postgres.html?utm_source=postgresweekly&utm_medium=email)Grouping (not in the SQL sense) some set of data into sets of activities is incredibly common when you want to reason about your data - here’s a great highlight of how to actually apply that from Periscope. Periscope [Insightful Postgres monitoring in real-time](http://dtdg.co/1OhYXXg)Datadog natively collects hundreds of Postgres metrics: system resources, connections, locks, transactions, indexes, and more. Pre-built, fully customizable visualizations, alerts, and full-stack performance correlation. 14 day unlimited trial. Datadog#sponsored[![\](https://copm.s3.amazonaws.com/d7c23730.png)](http://dtdg.co/1OhYXXg) [pg-table-markdown: Generate Markdown Documentation for Postgres Tables in a Given Schema](https://github.com/vokal/pg-table-markdown?utm_source=postgresweekly&utm_medium=email)A command line tool that generates markdown documentation for Postgres tables in a given schema. Vokal#code [The Troubleshooting Tales: Issues Scaling Postgres Connections](https://gocardless.com/blog/the-troubleshooting-tales-issues-scaling-postgres-connections/?utm_source=postgresweekly&utm_medium=email)Postgres connections are notoriously memory bloated, and the answer is generally a good connection pooler like PgBouncer. However, pgbouncer won’t solve all your problems, and here’s a great highlight of how you have to handle it with something like ActiveRecord. Harry Marr [Migrating a Rails App from MongoDB to PostgreSQL](https://www.amberbit.com/blog/2015/11/30/using-repository-pattern-to-migrate-rails-app-from-mongodb-to-postgresql/?utm_source=postgresweekly&utm_medium=email)A look at how some engineers migrated a legacy project from Mongo to Postgres, and some tips for doing it yourself. AmberBit [Help With Zero-Downtime Postgres Migrations on Rails](https://gocardless.com/blog/zero-downtime-postgres-migrations-a-little-help/?utm_source=postgresweekly&utm_medium=email)GoCardless has created a library, ActiveRecord::SaferMigrations, that automatically sets lock_timeout and statement_timeout before running migrations to prevent them stopping your app from responding to requests. Chris Sinjakli [Postgres Going in Multiple Directions](http://momjian.us/main/blogs/pgblog/2015.html?utm_source=postgresweekly&utm_medium=email#December_12_2015)Bruce Momjian has noticed Postgres going in multiple directions in terms of use-cases, including big data, data analytics, and NoSQL. Bruce Momjian [couch-to-postgres: Node Libary to Stream CouchDB Changes Into PostgreSQL](https://github.com/sysadminmike/couch-to-postgres?utm_source=postgresweekly&utm_medium=email) sysadminmike#code [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/136) [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