---
title: "Postgres Features You May Not Have Tried But Should"
publication: "Postgres Weekly"
issue: 261
published_at: "2018-06-20"
canonical_url: "https://postgresweekly.com/issues/261"
---

The latest Postgres news, articles, tools, and projects.       

#261 — June 20, 2018 

[Read on the Web](https://postgresweekly.com/issues/261)   

Postgres Weekly  

[Postgres Features You May Not Have Tried But Should](https://pgdash.io/blog/postgres-features.html?h) — Spoiler.. includes pub/sub, table inheritance, triggers, arrays, and more. 

RapidLoop   

[A Brief Performance Guide for PostgreSQL](https://severalnines.com/blog/performance-cheat-sheet-postgresql) — A quick run through of some of the principles behind making your database run more smoothly from analyzing queries to tweaking config settings. 

Sebastian Insausti   [![\](https://copm.s3.amazonaws.com/d8752bf9.png)](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-primary) 

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-primary) — Get a Linode server up and running in seconds. Simply choose your plan, distro and location and you’re ready to deploy your server. Get $20 credit on a new account. 

Linode Cloud Hosting sponsor   

[Scalable Incremental Data Aggregation on Postgres and Citus](https://www.citusdata.com/blog/2018/06/14/scalable-incremental-data-aggregation/) — A new approach to building rollup tables that provides more a ‘real time’ view of data that’s resulted in a 4 node Citus cluster being able to:  Ingest and aggregate over a million rows per second   Keep the rollup table up-to-date within ~10s   Answer analytical queries in under 10ms  

Marco Slot (citusdata)    

[How to Produce Histograms from a Query in Postgres](http://blog.faraday.io/how-to-do-histograms-in-postgresql/) — Somehow we missed this at the time, but this is really neat. 

Bill Morris   

[An Introduction to Indexing and B-Trees](https://medium.com/@rrfd/indexing-and-b-trees-applications-in-postgres-fdaf5cee5dba) — Ever wonder what happens under the covers when you run CREATE INDEX in Postgres? Learn more about what a B-Tree index is and how it works. 

Robert R.F. DeFilippi   

[Using Window Functions for Time Series IoT Analytics in Postgres-BDR](https://blog.2ndquadrant.com/window-functions-time-series-iot-analytics-postgres-bdr/) 

Muhammad Haroon (2ndQuadrant)   

[Scaling Past The Single Machine](https://www.modio.se/scaling-past-the-single-machine.html) — How using PostgreSQL 10 native partitioning, postgres_fdw and btrfs for storage can cut down disk usage while maintaining performance. 

Modio   

[How Heap Built an Analytics Platform that Auto-Tracks Every User Event](https://stackshare.io/heap/how-heap-built-an-analytics-platform-that-auto-tracks-every-user-event) — The tech stack behind Heap and the real application and data infrastructure, utilities, devops, and business tools Heap is using (which includes Postgres). 

StackShare   

[How Redshift Differs From PostgreSQL](https://www.stitchdata.com/blog/how-redshift-differs-from-postgresql/) — If you’re familiar with PostgreSQL features and syntax, how easy will it be to get used to Redshift, the AWS data warehouse service? 

Lee Schlesinger   

[pgwatch2: A Postgres Metrics Monitor/Dashboard](https://github.com/cybertec-postgresql/pgwatch2) 

Cybertec Schönig Schönig GmbH   

[repmgr 4.0.6: A Postgres Replication and Failover Management Tool](https://www.postgresql.org/about/news/1863/) 

2ndQuadrant   

[IoT Solution Using Geo-Distributed AlwaysOn Postgres-BDR](https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/iot-solutions-2ndquadrant/?utm_source=cpweekly&utm_medium=text&utm_campaign=cpiot) 

2ndQuadrant PostgreSQL Products sponsor   

[pgdeltastream: Stream Postgres Logical Replication Changes Over WebSockets](https://github.com/hasura/pgdeltastream) 

Hasura   

[node-pg-migrate: Node.js Database Migration Management for Postgres](https://github.com/salsita/node-pg-migrate) 

Salsita Software  

Events  

[PGDay France](http://pgday.fr/) — **June 26 (Marseille, France)** The place to meet the French speaking PostgreSQL community.    

[PGConf Brazil 2018](http://www.pgconf.com.br/2018_en/) — **August 3 - 4 (São Paulo, SP, Brazil)** Two day conference with talks, tutorials, Couch Clinic, FishBowl and Lightning Talks.    

[PostgreSQL Day 2018](https://pdx.postgresql.us/pdxpgday2018) — **September 10 (Portland, Oregon)** A day of presentations about PostgreSQL, an open source relational database management system.          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom