Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
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
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.