Postgres Weekly Issue 70
August 27, 2014
Checking for PostgreSQL Bloat
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
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
ZDNet
Biggish Data With Rails and PostgreSQL
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
postgres-xl
Relational Database Technologies: Deadlocks in PostgreSQL
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
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