---
title: "#215: A Tool to Create Hypothetical Indexes in Postgres"
publication: "Postgres Weekly"
issue: 215
published_at: "2017-07-12"
canonical_url: "https://postgresweekly.com/issues/215"
---

Postgres Weekly 215   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 215 — July 12, 2017     

[hypopg: Hypothetical Indexes for Postgres](https://github.com/dalibo/hypopg?utm_source=postgresweekly&utm_medium=email)Sometimes with Postgres you don’t know what will happen if you add an index, will things be faster/slower, will it have made an impact? The HypoPG extension aims to help with _hypothetically_ creating them so you can see what would happen ahead of time. Dalibo#code [Using Heroku's Expensive Query Dashboard](https://blog.heroku.com/expensive-query-speed-up-app?utm_source=postgresweekly&utm_medium=email)A look at a tool for investigating Postgres performance issues on Heroku-hosted apps. Richard Schneeman [PEV: A Postgres EXPLAIN Visualizer](http://tatiyants.com/pev/?utm_source=postgresweekly&utm_medium=email#/plans/new)Designed to make Postgres query plans easier to understand. [Further explanation here.](http://tatiyants.com/postgres-query-plan-visualization/) Alex Tatiyants#tools [RAM increased across all plans. Now get 2GB of RAM for only $10/mo.](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly)Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code `POSTGRES20` Linode#sponsored[![\](https://copm.s3.amazonaws.com/9925772c.png)](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly) [Postgres at Any Scale​](https://www.youtube.com/watch?v=_wU2dglywAU&utm_source=postgresweekly&utm_medium=email)A 35 minute talk on properly tuning an app and Postgres DB. He goes from the basics of just getting started up to managing terabytes of data. Will Leinweber#video [ldap2pg 1.0: Synchronize Postgres Roles From LDAP Directories](https://ldap2pg.readthedocs.io/en/latest/?utm_source=postgresweekly&utm_medium=email)A tool to synchronize Postgres roles from LDAP directories, including OpenLDAP & Active Directory. Dalibo#tools [A Brief Tale of Why to Use Postgres Views](https://dev.to/thepracticaldev/the-what-and-why-of-postgresql-views?utm_source=postgresweekly&utm_medium=email)_4 minute video._ Anna Rankin#video [Blog: Migrating Oracle Databases to Postgres on Amazon RDS](https://selectstar.io/blog/migrating-oracle-databases-postgresql-amazon-rds/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=PostgresRDS_Blog)See how to migrate to PostgreSQL on RDS in three steps. SelectStar#sponsored [PostgresOpen Silicon Valley - Session Line-up](https://postgresql.us/events/sessions/pgopen2017/?utm_source=postgresweekly&utm_medium=email)The PostgresOpen Silicon Valley session line-up is now live and it looks like a great line-up. Take a look and grab your ticket while there's one day of [early bird tickets](https://2017.postgresopen.org/tickets/) left. United States PostgreSQL Association#news [PGConf Local: Seattle 2017 Registration Open and Schedule Published](http://blog.pgconf.us/2017/07/pgconf-local-seattle-2017-registration.html?utm_source=postgresweekly&utm_medium=email)Taking place on August 11th and 12th at the Sheraton Downtown Seattle. Joshua Drake#news [Using S3 to Store Your MySQL or PostgreSQL Backups](https://medium.com/@francescoboffa/using-s3-to-store-your-mysql-or-postgresql-backups-6060415d11be?utm_source=postgresweekly&utm_medium=email) Francesco Boffa [Fast CSV Report Generation with Postgres in Rails](https://shift.infinite.red/fast-csv-report-generation-with-postgres-in-rails-d444d9b915ab?utm_source=postgresweekly&utm_medium=email)Using the PostgreSQL COPY command and response streaming it’s possible to serve large reports to the end user. Red Shift [What Should a PostgreSQL Migrator Do?](https://medium.com/@jonathangfischoff/what-should-a-postgresql-migrator-do-47fd34804be?utm_source=postgresweekly&utm_medium=email)One of the tricky parts of programming against a database is ensuring the database schema in production is compatible with the code. Jonathan Fischoff    

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