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

Postgres Weekly 99   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 99 — April 1, 2015     

[Governor: A Toolkit to Orchestrate High Availablity Postgres](https://blog.compose.io/open-sourcing-compose-governor-toolkit-for-running-ha-postgres/?utm_source=postgresweekly&utm_medium=email)Since there’s not a ton of out of the box easy to use solutions for HA Postgres, Compose has released a template for you to create your own custom fit high availability solution using etcd and Python. Compose#tools [Dirty PostgreSQL Database? Clean it up with a VACUUM](http://www.vertabelo.com/blog/technical-articles/dirty-postgresql-database-clean-it-up-with-a-vacuum?utm_source=postgresweekly&utm_medium=email)When you delete a row in Postgres, it doesn’t actually delete, well it does eventually. When you delete a row it marks it as logically deleted, here’s how you can ensure it’s gone as well as a read on how it works with MVCC under the covers. Vertabelo#tutorial [Browser-based query tool and PostgreSQL client](https://www.jackdb.com/?utm_source=postgresweekly&utm_medium=email)Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free. JackDB#sponsored[![\](https://copm.s3.amazonaws.com/1396702f.png)](https://www.jackdb.com/?utm_source=postgresweekly&utm_medium=email) [JSONB Type Performance in PostgreSQL 9.4](http://blog.2ndquadrant.com/jsonb-type-performance-postgresql-9-4/?utm_source=postgresweekly&utm_medium=email)JSONB arrived in Postgres 9.4 to a lot of excitement, but how does it really measure up? Here’s a look a performance, and how to really take advantage of it with the new operators which can utilize GIN indexes. 2ndQuadrant [Postgres 9.5 Feature Highlight: Scale-out with Foreign Tables Now Part of Inheritance Trees](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-foreign-table-inheritance/?utm_source=postgresweekly&utm_medium=email)Foreign tables now present an even cleaner solution for partitioning your data with inheritance. While you’ll have to wait a little until 9.5 is available, this feature clearer can make the scale out process in Postgres a bit more comfortable for all. Michael Paquier [PostgreSQL Data Sync 15.3 Released](http://www.postgresql.org/about/news/1579/?utm_source=postgresweekly&utm_medium=email) PostgreSQL.​org#news [Sorting by Popularity (Reddit-style) with Ruby, PostgreSQL and Elasticsearch](http://inaka.net/blog/2015/03/25/hot-score-with-ruby-postgresql-and-elastic-part-1/?utm_source=postgresweekly&utm_medium=email)First part of a series showing how we can sort items by popularity in a Ruby application following the Reddit style, using PostgreSQL and Elasticsearch. Flavio Granero [Vector Tiles](http://javisantana.com/2015/03/22/vector-tiles.html?utm_source=postgresweekly&utm_medium=email)Following on from a debate about the naming of Mapbox Vector Tiles, this post instead digs right into where they’re valuable and gets hands on with them. A great overview. Javi Santana [An Awesome Way To Migrate to PostgreSQL from MySQL](http://blog.zanclus.com/2015/03/an-awesome-way-to-migrate-to-postgresql.html?utm_source=postgresweekly&utm_medium=email) Deven Phillips [cstore_fdw 1.2: Fast columnar store for analytics with PostgreSQL.](https://github.com/citusdata/cstore_fdw?utm_source=postgresweekly&utm_medium=email)CStore - The fast and open source columnar store for analytics with PostgreSQL just received a new release which features some nice improvements. If you haven’t played with it yet, this is a good excuse. Citus Data#code [Why Not Postgres? #1: Multi-Consumer FIFO Push Queue](http://distdepot.com/blog/2015/why-not-postgres-1-multi-consumer-fifo-push-queue/?utm_source=postgresweekly&utm_medium=email)Any article that starts off “PostgreSQL is so much more than a simple relational data store” makes me happy. A look at how Postgres is not only a great relational database, but can also work as a very solid queue for your application. DistDepot    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/99) [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