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

Postgres Weekly 111   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 111 — June 24, 2015     

[Discovering the Computer Science Behind Postgres Indexes](http://blog.codeship.com/discovering-computer-science-behind-postgres-indexes/?utm_source=postgresweekly&utm_medium=email)Don’t stop with just learning all the index types in Postgres (BTree, Gin, GiST, Sp-GiST, KNN, conditional, functional) make sure you go further and check out this final in the installment of what happens when you issue a query and how indexes actually work under the covers. Pat Shaughnessy [Fashion Is Hard. PostgreSQL Is Easy](https://tech.zalando.com/blog/watch-fashion-is-hard-postgresql-is-easy/?utm_source=postgresweekly&utm_medium=email)Zalando’s Head of Data Engineering, Valentine Gogichashvili, shares their experiences with PostgreSQL and how it fared scaling up to 100 million visitors per month. Zalando#video [Oracle's Biggest Database Foe: Could It Be Postgres?](http://www.techrepublic.com/article/oracles-biggest-database-foe-could-it-be-postgres/?utm_source=postgresweekly&utm_medium=email)An EnterpriseDB survey showed 77% of users are dedicating all new deployments to PostgreSQL with 37% reporting they had migrated existing apps from Oracle or Microsoft SQL Server to Postgres. TechRepublic#opinion [Unleash Real-Time Big Data on PostgreSQL with CitusDB](https://www.citusdata.com/citus-products/citusdb-software)CitusDB delivers [real-time end user insights](https://www.citusdata.com/applications/real-time-analytics) into your big data while reducing the cost and complexity of your database infrastructure and leveraging your existing PostgreSQL knowledge and applications. Supports structured or unstructured data and [elastically scales.](https://www.citusdata.com/applications/scaling-out-postgresql) Citus Data#sponsored[![\](https://copm.s3.amazonaws.com/654be4d1.png)](https://www.citusdata.com/citus-products/citusdb-software) [Heroku PostgreSQL vs. Amazon RDS for PostgreSQL](http://blog.codeship.com/heroku-postgresql-versus-amazon-rds-postgresql/?utm_source=postgresweekly&utm_medium=email)If you want to use Postgres, but not run and maintain it yourself, Heroku or AWS are two compelling options. This is a thorough rundown of what you can expect from each. Barry Jones#opinion [How to Debug Postgres using LLDB on a Mac](https://gist.github.com/patshaughnessy/70519495343412504686?utm_source=postgresweekly&utm_medium=email)Very deep technical stuff, tread with care. Pat Shaughnessy [Aggregate Queries Across PostgreSQL Schemas](http://clarkdave.net/2015/06/aggregate-queries-across-postgresql-schemas/?utm_source=postgresweekly&utm_medium=email)Schemas are an often (but not always) awesome means for splitting up some data across different tables; think of them as good for lightweight sharding. But often when you split data up this way you want aggregate it up for some level of reporting, here’s a nice walk through of such. Dave Clark [Connecting Neo4j to Any SQL Tool with the Power of Postgresql](http://www.bsimard.com/Connecting-Neo4j-to-any-SQL-tool-with-the-power-of-Postgresql?utm_source=postgresweekly&utm_medium=email)A Python and Multicorn-based foreign data wrapper that brings together Neo4j and Postgres. Benoît Simard#tools [Getting Postgres Version With Golang](http://datachomp.com/archives/getting-postgres-version-with-golang/?utm_source=postgresweekly&utm_medium=email)A small but handy utility if you’re in ops on how to grab the Postgres version and then potentially other information about it from within Go. Rob Sullivan#code [pg_idx_advisor: Index Advice for PostgreSQL](http://pgxn.org/dist/pg_idx_advisor/?utm_source=postgresweekly&utm_medium=email)While it won’t be a magic bullet, this extension could certain add a ton of value and performance to your system by providing index recommendations for your databases. Jony Vesterman Cohen#tools#code    

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