Oct 2019 Citus Newsletter (now part of Microsoft)

Auto Failover with PostgreSQL 12

Earlier this month the PostgreSQL community announced the release of PostgreSQL 12! You’ll be pleased to know that we released  pg_auto_failover 1.0.5 with Postgres 12 compatibility, and already published our packages. In this post, Dimitri explains what pg_auto_failover is, and the changes that were needed for Postgres 12 compatibility.
Read Dimitri’s post →

Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension

How does the Windows team at Microsoft assess the quality of new software builds to decide if the next software update is ready to ship? And how do they scale out Postgres on Azure—using Citus—to power a petabyte-scale analytics dashboard, analyzing 20K types of metrics from over 800M Windows devices? Claire Giordano interviewed engineer Min Wei of Microsoft to find all the answers.
Read about Min Wei’s architecture →

Auditing: Know what's going on in your Postgres database

Today it's almost unsurprising to see another headline related to data breaches or data privacy. In this post, Rachel explains why good audit logging is one important tool in the belt of a security-aware data professional.
More on audit logging →

Troubleshoot PostgreSQL: ‘An existing connection was forcibly closed by the remote host’

Application logs may show intermittent connection errors or other error messages that indicate a timeout, write failure or a pipe error. Very shortly afterwards, the PostgreSQL logs show an error as well. These two events are interrelated and are frequently associated with client-side connection handling issues. These types of errors can be tricky to troubleshoot because different components are involved. In this blog post, Richard & Bashar, engineers on the Postgres team, discuss what can lead to these errors and best practices for avoidance.
Troubleshooting tips →

Visit the Azure Database for Postgres Team at Microsoft Ignite

The Azure Open Source Databases Engineering team will be presenting several sessions on cool new innovations at Microsoft Ignite 2019 in Orlando, FL Nov 3-8, 2019. And, if you can’t attend, a live stream of many sessions will be available.
Get the deets →

Rob Conery’s Article: Fine tuning Full Text Search with Postgres 12

Rob Conery has written about Full Text Search before, focusing on speed and general use. This time he’s focused on relevance. Using data from the NDC Sydney conference earlier this month, Rob takes us through different types of searches and the useful strategies needed for building a full text index. Complicated, and FUN!
Play along with Rob →

Materialized views vs. rollup tables in Postgres

Materialized views and rollup tables are both great ways to aggregate data for faster dashboards and reports, but it's not always clear which to use when. In this post, Craig explains the difference between materialized views and rollup tables in Postgres, and provides some criteria to help you decide which is best for your data set and workload.
Learn why we think rollups scale better →

Interesting Upcoming PgDays

PgDays—the 1-day, 1-track PostgreSQL conference where developers, users, community members, & experts all participate in the same conversation. Craig shines a light on these special Postgres events—including the just-announced PgDay San Francisco in January, plus Nordic PGDay and pgDay Paris in March.
Craig loves PgDays →

ICYMI: Login and Permission Tips and Tricks in using pg_dump and pg_restore

We share some tips and tricks that will help you in executing pg_dump and pg_restore when you are migrating data from on-premise to the cloud. pg_dump and pg_restore are commonly used in data movement between PostgreSQL servers. Best practices for pg_dump and pg_restore assume access to superuser accounts, which are not always available in cloud offerings.
Read the post →

pgDay Santiago, PostGIS Day, and PgDay San Francisco:

Is Citus right for you?

Want to explore whether Citus is right for you and your use case? Learn more about the Citus product, check out the documentation, or watch this short demo of Hyperscale (Citus) on Azure Database for PostgreSQL.