---
title: "This Week's PostgreSQL News (#183)"
publication: "Postgres Weekly"
issue: 183
published_at: "2016-11-16"
canonical_url: "https://postgresweekly.com/issues/183"
---

Postgres Weekly 183   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 183 — November 16, 2016     

[A Set of Postgres Practices to Follow](http://kukuruku.co/hub/programming/postgresql-set-of-practices?utm_source=postgresweekly&utm_medium=email)22 rules of thumb for Postgres picked up from years of working with it. Denis Smirnov#opinion [postgresql-unit: SI Units for PostgreSQL](https://github.com/ChristophBerg/postgresql-unit?utm_source=postgresweekly&utm_medium=email)PostgreSQL is pretty flexible when it comes to datatypes. Many are built in and some are custom, here’s a new custom one for SI units. Christoph Berg#code [Setting up a Postgres Sandbox](http://verticalsysadmin.com/blog/setting-up-a-postgres-sandbox/?utm_source=postgresweekly&utm_medium=email)16 steps to setting up a reproducible Postgres sandbox inside a disposable VM. Mike Weilgart#tutorial [Win a ticket to the CHAR(16) Conference](https://www.2ndquadrant.com/landing/CHAR16_Contest/)PostgreSQL Scalability for Business is a hot topic right now and we’re giving away 2 tickets to hear from the experts first-hand at CHAR(16) on Dec 6th in New York. See above link for more details on how to enter. 2ndQuadrant#sponsored[![\](https://copm.s3.amazonaws.com/596c7fcc.jpg)](https://www.2ndquadrant.com/landing/CHAR16_Contest/) [Citus 6.0: A Database Designed for Multi-Tenancy](https://www.citusdata.com/blog/2016/11/14/introducing-citus-6/?utm_source=postgresweekly&utm_medium=email)Citus 6.0, an open-source extension, is here with a number of new features, such as improvements to make scaling out multi-tenant apps easier as well as distributed rollups of data. Citus Data#news [Amazon RDS Now Supports PostgreSQL 9.6.1](https://www.postgresql.org/about/news/1717/?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 supports a lot of new great features, with the highlight being parallel scans. Amazon RDS now supports it, so take a look at upgrading today. postgresql#news [Integrating Relational Data into Salesforce with Heroku External Objects & Heroku Postgres](https://developer.salesforce.com/blogs/developer-relations/2016/11/integrating-relational-data-salesforce-heroku-external-objects-heroku-postgres.html?utm_source=postgresweekly&utm_medium=email) Salesforce#news [How Heap Works, Part 1: 10 Million Indexes And Counting](http://blog.heapanalytics.com/how-heap-works-part-1-10-million-indexes-and-counting/?utm_source=postgresweekly&utm_medium=email)Heap powers a large scale analytics service using Postgres. Because of the amount of data they handle they face a number of challenges, here’s a look at how they make things work starting with a huge collection of indexes. Heap Analytics [dbglass: Simple, Modern and Fast Postgres Client](http://dbglass.web-pal.com/?utm_source=postgresweekly&utm_medium=email)An elegant open source client for Windows, OS X and Linux. Web-Pal#tools [Generate TypeScript Interface Definitions from Postgres Schemas](https://github.com/SweetIQ/schemats?utm_source=postgresweekly&utm_medium=email) sweetiQ Analytics Corp#tools [Pogi: JavaScript Library for Postgres and Node.js](https://github.com/holdfenytolvaj/pogi/?utm_source=postgresweekly&utm_medium=email) Geza Radics#code [atomicdb: PostgreSQL HA Configuration using Project Atomic](https://github.com/jberkus/atomicdb?utm_source=postgresweekly&utm_medium=email)Looking to get setup on Kubernetes and Postgres? Here’s a prototype that showcases Postgres on it complete with high availability. Josh Berkus#code [Find Your Perfect Fit - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Sick of pushy recruiters, and dead end interviews? Try Hired to hear from top tier companies, and only talk to relevant companies. Hired#sponsored    

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