#261 — June 20, 2018

Read on the Web

Postgres Weekly

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:

  • 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 — 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

    Events

    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.