#215: A Tool to Create Hypothetical Indexes in Postgres

.

Read this on the Web

Postgres Weekly Issue 215 — July 12, 2017

hypopg: Hypothetical Indexes for Postgres 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 A look at a tool for investigating Postgres performance issues on Heroku-hosted apps. Richard Schneeman PEV: A Postgres EXPLAIN Visualizer Designed to make Postgres query plans easier to understand. Further explanation here. Alex Tatiyants   #tools  RAM increased across all plans. Now get 2GB of RAM for only $10/mo. 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  Postgres at Any Scale​ 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 A tool to synchronize Postgres roles from LDAP directories, including OpenLDAP & Active Directory. Dalibo   #tools  A Brief Tale of Why to Use Postgres Views 4 minute video. Anna Rankin   #video  Blog: Migrating Oracle Databases to Postgres on Amazon RDS See how to migrate to PostgreSQL on RDS in three steps. SelectStar    #sponsored  PostgresOpen Silicon Valley - Session Line-up 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 left. United States PostgreSQL Association   #news  PGConf Local: Seattle 2017 Registration Open and Schedule Published Taking place on August 11th and 12th at the Sheraton Downtown Seattle. Joshua Drake   #news  Using S3 to Store Your MySQL or PostgreSQL Backups Francesco Boffa Fast CSV Report Generation with Postgres in Rails 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? 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 Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK