Most RecentMost LikesMost ViewedUK COVID-19 dashboard built using Postgres and Citus for millions of users Why and how the UK Coronavirus Dashboard team built their analytics service on top of PostgreSQL & Citus on Azure. Understanding partitioning and sharding in Postgres and Citus This partitioning vs. sharding post explores the benefits of Postgres partitioning and sharding with the Citus extension. When to use Hyperscale (Citus) to scale out Postgres One of the most common questions we get: when to use Hyperscale (Citus)? What use cases are a fit for scaling out Postgres? What’s new with Postgres at Microsoft, 2024 edition Overview of Postgres workstreams at Microsoft in the last 8 months, both open source and in the cloud on Azure. This 2024 edition is a newer, completely updated version of a popular blog post from August 2023. What’s new with Postgres at Microsoft (August 2023) Overview of the Postgres work done at Microsoft in the last year, both on Azure & in the open source community. How We Shipped PostgreSQL 14 on Azure Within One Day of its Release How we made Postgres 14 available in production on Azure in Hyperscale (Citus) just 1 day from the PG14 release. What’s new in Hyperscale (Citus) for Postgres on Azure (ft. read replicas) About all the ways we’ve made it easier to try & use the Hyperscale (Citus) option in Azure Database for PostgreSQL. Migrating interactive analytics apps from Redshift to Postgres, ft. Hyperscale (Citus) Learnings from migrating an analytics dashboard from Redshift to Hyperscale (Citus) on Azure Database for PostgreSQL. Making Postgres stored procedures 9X faster in Citus Learn how stored procedures in Hyperscale (Citus) are now 9X faster using a special technique called distributed functions. Sharding Postgres with Basic tier in Hyperscale (Citus), how why & when Basic tier makes it easy to get started with Hyperscale (Citus) & easy to adopt a distributed data model from the beginning.
