Postgres Features You May Not Have Tried But Should — Spoiler.. includes pub/sub, table inheritance, triggers, arrays, and more.

RapidLoop

A Brief Performance Guide for 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

Linux Cloud Hosting Starting at 1GB of RAM for $5/mo — 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 — 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:

Marco Slot (citusdata)

How to Produce Histograms from a Query in Postgres — Somehow we missed this at the time, but this is really neat.

Bill Morris

An Introduction to Indexing and B-Trees — 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

Muhammad Haroon (2ndQuadrant)

Scaling Past The Single Machine — 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 — 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 — 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

Cybertec Schönig Schönig GmbH

repmgr 4.0.6: A Postgres Replication and Failover Management Tool

2ndQuadrant

IoT Solution Using Geo-Distributed AlwaysOn Postgres-BDR

2ndQuadrant PostgreSQL Products sponsor

pgdeltastream: Stream Postgres Logical Replication Changes Over WebSockets

Hasura

node-pg-migrate: Node.js Database Migration Management for Postgres

Salsita Software

PGDay France — June 26 (Marseille, France) The place to meet the French speaking PostgreSQL community.

PGConf Brazil 2018 — August 3 - 4 (São Paulo, SP, Brazil) Two day conference with talks, tutorials, Couch Clinic, FishBowl and Lightning Talks.

PostgreSQL Day 2018 — September 10 (Portland, Oregon) A day of presentations about PostgreSQL, an open source relational database management system.