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

Postgres Weekly Issue 70 - August 27, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/70)**Postgres Weekly****Issue 70**
August 27, 2014[Checking for PostgreSQL Bloat](http://www.keithf4.com/checking-for-postgresql-bloat/?utm_source=postgresweekly&utm_medium=email)Bloat is a thing that can gradually creep up and affect your PG database. While not overly complicated, as it’s core to how Postgres works under the covers, it’s not the most understood part of the database for most developers, here’s a great write up on what it is and how to deal with it._Keith_[PoWA: A Postgres Workload Analyzer](https://dalibo.github.io/powa/?utm_source=postgresweekly&utm_medium=email)Need yet another option for analyzing the performance of your Postgres database? PoWA is a PostgreSQL workload analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers._DALIBO_[EnterpriseDB Aims for Easier NoSQL Dev with Free Postgres AWS Tools](http://www.zdnet.com/enterprisedb-aims-for-easier-nosql-dev-with-free-postgres-aws-tools-7000032743/?utm_source=postgresweekly&utm_medium=email)_ZDNet_[Biggish Data With Rails and PostgreSQL](https://www.youtube.com/watch?v=rVrsaL_PnYE=UUWnPjmqvljcafA0z2U1fwKQ?utm_source=postgresweekly&utm_medium=email)ORMs are great for early development and pretending your database is a black box will let you move even faster. Yet, at a certain point you have to admit it’s a real thing, here’s a recent talk from a conference that starts to address many of the challenges you’ll face._Cascadia Ruby 2014_[Postgres-XL: Open Source Scalable SQL Database Cluster](http://www.postgres-xl.org/?utm_source=postgresweekly&utm_medium=email)_postgres-xl_[Relational Database Technologies: Deadlocks in PostgreSQL](http://raghavt.blogspot.com/2011/11/deadlocks-in-postgresql.html?utm_source=postgresweekly&utm_medium=email)Deadlocks, while not overly common, can be a source of intense pain. Not sure even where to begin with what deadlocks are? Here’s a guide on different levels as well as digging deeper into them._Raghavendra_[Porting SQLite3 Data to PostgreSQL Database in Rails 4](http://blog.flatironschool.com/post/68064669290/porting-sqlite3-data-to-postgresql-database-in-rails-4?utm_source=postgresweekly&utm_medium=email)While dev/prod parity is often encouraged, it’s not always an option. In the case you’ve made serious progress with SQLite and need to get over to Postgres, here’s everything you need to know._Joe O’Conor_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|*)